• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Maximizing Office with VBA M... > Working with the Visual Basic Editor

Working with the Visual Basic Editor

To add existing macro code to a module, edit a recorded macro, or build your own macros from scratch, you use the Visual Basic Editor. You saw earlier that one way to open the Visual Basic Editor is to display the Macros dialog box, select a macro, and then click Edit. However, if you just want access to the editor, the more normal route is to select Tools, Macro, Visual Basic Editor, or click the Visual Basic Editor button in the Visual Basic toolbar (you can also press Alt+F11).

The Visual Basic Editor is a so-called integrated development environment, which means it has tools and objects that enable programmers to write and edit VBA code. The Visual Basic Editor is divided into three areas (as shown in Figure 11.4):


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint