O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the VBA Editor

The VBA Editor (see Figure 39.4) is a true work of art. It's easily the equal of any programming editor ever devised, although it also has some noteworthy shortcomings, which you'll learn about later in this section.

Figure 39.4. The VBA Editor usually contains two "dockable," resizable panes, plus a large open area for writing programs and creating custom dialog boxes.

To open the VBA Editor in Word, Excel, PowerPoint, Outlook, FrontPage, or Access, choose Tools, Macro, Visual Basic Editor. The VBA Editor sits in its own window, separate from the Office application that opened it.

Managing VBA Components with Project Explorer ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required