在Excel中利用VBA动态绘制交互式函数平面曲线

Dynamic Drawing Interactive Function Plane Curve in Excel Using the VBA

在剖析Excel VBA编程方法的基础上,提出了将工作表设置成坐标纸,利用其数据源和VBA编程手段并采用描点法动态绘制交互式函数平面曲线的方法,为丰富数学、物理、电子等诸多跟绘图有关课程的教学手段提供了一种新的途径,文章就有关方法及技术做了详细介绍,并给出了可绘制任何函数平面曲线的Excel VBA源代码。

On the basis of analyzing the method of Excel VBA programming, this paper puts torwara me memod of setting the work table into coordinate paper, making use of the data source and VBA programming method and drawing the interactive function plane curve by tracing point method. It provides a new way to enrich the teaching methods of mathematics, physics and electronics, which related to drawing. In this paper, the methods and techniques are described in detail, and gives the function of any curve can be drawn Excel VBA source code.