Microsoft Office Tutorials and References
In Depth Information
The standard toolbar, directly under the menu bar by default, is one of six VB Editor toolbars. You can custom-
ize toolbars, move them around, dock them, display additional toolbars, and so forth.
The Project window displays a tree diagram that consists of every workbook that's open in Excel (including
add-ins and hidden workbooks). In the VB Editor, each workbook is a project. I discuss the Project window in
more detail in the upcoming section, “Using the Project window.” If the Project window is not visible, press
A code window contains VBA code. Just about every item in a project has an associated code window. To view
a code window for an object, either double-click the object in the Project window, or select the item and then
click the View Code button at the top of the Project window.
For example, to view the code window for the Sheet1 object for a particular workbook, double-click Sheet1 in
the Project window. Unless you've added some VBA code, the code window will be empty. I discuss code win-
dows later in this chapter (see the “Using code windows” section).
The Properties window contains a list of all properties for the selected object. Use this window to examine and
change properties. You can use the F4 shortcut key to display the Properties window.
The Immediate window is most useful for executing VBA statements directly, testing statements, and debug-
ging your code. This window may or may not be visible. If the Immediate window is not visible, press Ctrl+G.
To close the Immediate window, click the Close button on its title bar.
One rather significant VBA-related change in Excel 2013 is the Help system. All VBA help is via the Internet. In
other words, if you're working at a location with no Internet service, you cannot get help with VBA.
Using the Project window
When you work in the VB Editor, each Excel workbook and add-in that's open is a project. You can think of a
project as a collection of objects arranged as an outline. You can expand a project by clicking the plus sign (+)
at the left of the project's name in the Project window. To contract a project, click the minus sign (–) to the left
of a project's name. Figure 23-7 shows the Project window with two projects listed. One of the projects
(MyFunction.xlsm) is expanded to show its components.