Microsoft Office Tutorials and References
In Depth Information
The Project Explorer Window
The project Explorer Window
The Project Explorer is a vertical pane on the left side of the VBE. It behaves similarly to
Windows Explorer, with folder icons that expand and collapse when clicked. If you do not see the
Project Explorer window in your VBE, press Ctrl+R, or from the VBE menu bar, click View ➪
Project Explorer. As the first item showing at the top of the Project Explorer window in Figure 3-3,
the name of the workbook I am using (in Excel terms, the VBAProject) is MacroExamples.xlsm.
VBA code is kept in objects known as modules , which are discussed later in further detail.
Figure 3-3 shows one module called Module1. Double-clicking a module name in the Project
Explorer displays that module’s VBA code contents in the Code window, as you see in Figure 3-3.
The code Window
The Code window is where the code for macros and VBA procedures is located. The VBE provides
separate code windows for each module. A good way to think of this is, for every object (worksheet,
module, and so on) you see listed in the Project Explorer, the VBE has provided a code window.
You will note that the drop-down in the upper right-hand corner of Figure 3-3 displays the name of
the macro that is currently showing in the Code window ( mySort ). As you create multiple macros,
you can use this drop-down to quickly move from one macro to another.