Visual Basic for Applications(VBA) is a macro language of Visual Basic and a programming language developed by Microsoft, which is used to perform general automation (OLE) tasks in its desktop applications. It can be 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. The application developed by Microsoft in 1993 enjoys a common automation language, Visual Basic for Application(VBA). In fact, VBA is a version parasitic on VB applications. Microsoft has the macro function of VBA in Excel5.0 released by 1994.
Extended data:
The difference between VBA and VB;
1.VB is an application that aims to create standards, while VBA is to automate existing applications (EXCEL, etc.). ).
2.VB has its own development environment, and VBA must be parasitic on existing applications.
3. To run the application developed by VB, users do not need to install VB, because the application developed by VB is an executable file (*. EXE), and the program developed by VBA must rely on its parent application, such as EXCEL.
4.VBA is a subset of VB.
Baidu Encyclopedia -VBA (Visual Basic Macro Language)