A macro language of Basic, which is mainly used to expand the application functions of Windows, especially Microsoft.
Office software. It can also be said that it is the basic script of application visualization. Excel 5.0 published by 1994 has the macro function of VBA.
What is an Excel application? Based on Excel and VBA, the spreadsheet developed is called Excel application.
What is a macro? Macros are a series of commands and functions, which are stored in modules of Visual Basic and can be run at any time when tasks need to be performed. If you often repeat a task, you can use a macro to automatically perform the task.
These are the three concepts of VBA, so why use VBA? Why use Excel as a platform for developing programs?
Here are a few simple reasons!
1. When using Excel as a platform, your program can take advantage of the existing functions of Excel and stand on the shoulders of a little giant, which can greatly shorten the development cycle.
2. Almost all computers have Excel, and a large number of people are using Excel, but not everyone can use VBA. When you understand VBA, many previous problems may be solved here.
3. Excel development programs are easy to distribute. As long as there is Excel in the computer, there is basically no need to simply copy and paste other files, and file distribution is completed.
4.VBA language is relatively easy to learn and master. If you are familiar with VB, you will find that they are similar in language. If you know more about Excel, you will easily understand various objects of Excel.