The programming, structure, algorithm, code realization and output mode of VBA, a survey data calculation program, is presented in the paper on basis of the software of Excel. The program of VBA is applied in the highway construction survey, which optimizes and extends the functions of Excel and meets the requirements more professionally. The program of VBA is more simple and has stronger functions than the calculator program of fx4800P and improves the working efficiency and accuracy greatly.