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 ...

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.