Selecting the VBA Editor command launches Microsoft’s Visual Basic for Applications (Microsoft Visual Basic Application) which allows you to create or modify an existing macro.
In order for the VBA Editor to open you must first load a Microsoft Visual Basic Application project. You may load a project by selecting the command button Tools > Macros > Macro Projects > Add macro.
There are several ways to open up the Microsoft Visual Basic Application Editor:
▪Click Tools > Macros > Microsoft Visual Basic Application Editor.
▪Press Alt+F11.
▪In the Macros dialog, click Edit.
▪In the Macro Projects dialog, click Apply (if active) and then on the Run Macro... command button. This will open the Macros dialog where the Edit command button can be found.