Abstract: In order to improve the automation of the surface movement observation station in design and the efficiency of data processing and mapping of movement and deformation curve，based on the programming language of Visual Basic(VB) and Visual Basic for Application （VBA)，the functions such as query of parameters，computation of observation line，observation station design，output of data，data processing and automatic mapping of surface movement observation station are realized by adopting the technology of Access，AutoCAD and Excel.Firstly，the surface and linear route movement observation stations at working face are arranged quickly by using the AutoCAD software；then the observation data are processed automatically and the deformation and movement graphs are mapped based on the Excel software.In addition，the function of axis label of scatter chart with a smooth line is optimized；Finally，both of the functions are integrated into one program to realize the function module integration so as to overcome the insufficiency of single function，low degree of automation and difficulty in modification.The research results show that，the program written in this paper can satisfy the needs for variable observation station design and the special requirement of mapping the movement and deformation curve.Besides that，this program is conducive to improve the automation degree of mining surface movement observation and it can also provide some reference for establishing the surface movement observation system.

Key words: Surface movement observation station, Data processing, Movement deformation curve, VB, VBA, Surface movement observation system