Mastering VBA can play the following roles:
1. Standardize user operation and control user operation behavior;
2. Humanized operation interface, which is convenient for users to operate;
3. By executing VBA code, multi-step manual operation can be realized quickly;
4. Realize some functions that VB can't. ?
5. Making EXCEL login system with VBA. ?
6.VBA can be used to easily develop powerful automation programs in Excel.
Extended data:
The macro language VBA is suitable for all applications in Office 2000, including Word, Excel, PowerPoint, Access, Outlook and Project. In every application of Office 97, a Visual Basic editor has been added. In this way, users have a unified method and standard to establish and manage VBA in Excel, Word and even Access.
VBA has access to many operating system functions and supports the automatic execution of macros when a document is opened. This makes it possible to write computer viruses in this language. Macro virus became one of the most popular computer viruses in the middle and late period of 1990. Other projects, including macro language, such as OpenOffice.org, deliberately excluded some functions (such as automatic execution) from its macro language in order to avoid damaging the program. However, this feature is welcome in many affairs.
VBA is developed based on Visual Basic, and they have similar language structures. Visual Basic is Microsoft's main graphical interface development tool, and VBA 5.0 (namely VBA 97) is a subset of Visual Basic 5.0. Visual Basic is the fourth generation language developed from Basic. As an independent Windows system development tool, Visual Basic can develop various applications in the Windows environment. It is a visual, object-oriented and event-driven structured high-level programming language. It has the characteristics of high efficiency, easy learning and powerful function.
Baidu encyclopedia -VBA