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.

As you become more proficient, you might want to ...

Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.