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

Chapter 38. Using Macros to Automate Off... > Secrets of the Office Masters: Getti...

Secrets of the Office Masters: Getting Ready to Tackle VBA

Ready to start working with VBA? Good. Take a few moments to organize your screen and customize the VBA Editor. That way, you won't have to hunt and click so much to get going. (To start the VBA Editor, just start your favorite Office application and press Alt+F11.)

Most VBA aces believe that the best way to arrange VBA and any Office application is by putting the application in the top half of the screen and the VBA Editor in the bottom half, as you can see in this figure. That way, you can step through your program, keeping track of the active command in the bottom window, while watching the effects of your program in the top window.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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