Abstract:Based on work experiences in many years, combining with actual examples, application method and techniques of VBA(Visual Basic for Application) which is the inner couplers developing tool of Excel have been studied. Mathematics calculation with complicated operation steps and a great deal of datas in the process have been solved. It will effectively eradicate mistakes brought by artificial operation.