Page 71 - Microsoft Office Excel 2003 Programming Inside Out

VBA Programming Starter Kit

Table 4-1. Menu Items Available on the View Menu in the Visual Basic Editor
Item Description
Last Position Returns the cursor to the beginning of the last line of code edited.
Object Browser Displays or activates the Object Browser window.
Immediate Window Displays or activates the Immediate window.
Locals Window Displays or activates the Locals window.
Watch Window Displays or activates the Watch window.
Call Stack Displays or activates the Call Stack dialog box.
Project Explorer Displays or activates the Project Explorer window.
Properties Window Displays or activates the Properties window.
Toolbox€ Displays or activates the Toolbox, which contains objects used to
design user forms.
Tab Order Displays or activates the Tab Order dialog box.
Toolbars€ Lets you turn on and off the various toolbars available within the
Visual Basic Editor as well as customize them.
Microsoft Office Excel € Switches to the active workbook, restoring the display if it is
minimized.

The Insert Menu
The Insert menu lets you insert new procedures, modules, or user forms into your project.
Table 4-2 summarizes the items available on the Insert menu in the Visual Basic Editor.
Table 4-2. Menu Items Available on the Insert Menu in the Visual Basic Editor Chapter 4

Item Description
Procedure€ Displays the Add Procedure dialog box to help you build the
declaration statement for a new procedure inside the current module.
UserForm Inserts a new user form into the current project.
Module Inserts a new module into the current project.
Class Module Inserts a new class module into the current project.
File€ Displays the File Open dialog box to allow you to import a text file
(*.txt), a Basic file (*.bas), or a class file (*.cls). Text files will be
inserted into the current Code window, whereas Basic or class files
will be inserted into the current project as separate modules or
class modules.

45
Part 2: Visual Basic for Applications