Parts of the VBA Editor

The VBA editor is shown in Figure 3.1. Since the VBA editor can be customized, it will not always look just like this, but this is the general appearance it will have when you first start using it. At the top, of course, are the menu bar and the toolbar from which you select the various editor commands. Of interest to us are the four windows displayed below the toolbar. They are as follows:

  • Editing window. Displays VBA code for editing and User Forms for design.

  • Project Explorer window. Displays the loaded VBA projects and the components of each project.

  • Properties window. Used to view and edit the properties of the current object.

  • Immediate window. Displays the output of debugging statements in your code.

Figure 3.1. ...

Get Office® XP Development with VBA 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.