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

The VBE

You learned earlier in this chapter how you can use the macro recorder to generate Visual Basic code, but for more complicated macros, you will want to start in the VBE. You saw earlier how to open the VBE (by using Alt+F11) and use it to modify a macro. The following sections describe some features the VBE offers and how to work with them.

The Project Explorer

You saw the Project Explorer window earlier, when you were looking for the module where the macro you created was stored. The Project Explorer is typically docked in the upper-left corner of the screen. The top project is usually GLOBAL.MPT, and this is a good place to put macros you are working on or that you want to use across several projects.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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