Microsoft Office Tutorials and References
In Depth Information
Introducing the Visual Basic Editor
The VB Editor components
The VB Editor consists of a number of components. I briefly describe some of the key
components in the following sections.
The VB Editor in Excel 2010 still uses the old-style menu and toolbar interface rather
than the newer Ribbon interface.
The VB Editor menu bar is like the menu bar for most Windows applications. It contains
commands that you use to work with the various components in the VB Editor.
The VB Editor also features shortcut menus. Right-click virtually anything in a VB Editor window
to get a shortcut menu of common commands.
The standard toolbar, directly under the menu bar by default, is one of six VB Editor toolbars that
are available. You can customize 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 currently
open in Excel (including add-ins and hidden workbooks). In the VB Editor, each workbook is
known as 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 Ctrl+R.
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,
doubleclick Sheet1 in the Project window. Unless you’ve added some VBA code, the code window will
be empty. I discuss code windows 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.