Page 74 - Microsoft Office Excel 2003 Programming Inside Out

Microsoft Office Excel 2003 Programming Inside Out

The Run Menu
The Run menu contains several commands that allow execution of program code and the
display of user forms. Table 4-5 lists the items available on the Run menu.

Table 4-5. Menu Items Available on the Run Menu in the Visual Basic Editor
Item Description
Run Sub/UserForm€ Start executing the current procedure or user form. If none is
selected, the Run Macro dialog box is displayed, allowing you to
select a procedure to run. When a procedure is running and in
Break mode, this command will change to Continue to allow you
to continue normal execution of the procedure.
Break€ Lets you stop execution of the procedure and places the code
in Break mode.
Reset Lets you reset all module-level variables and clear the Call Stack.
Design Mode€ Lets you toggle Design mode on and off for the selected
procedure.

The Tools Menu

The Tools menu gives you commands to run procedures, add references to external proce­
dures, set options for the Visual Basic Editor, set properties for the current project, and
digitally sign the project. Table 4-6 lists the items available on the Tools menu.

Table 4-6. Menu Items Available on the Tools Menu in the Visual Basic Editor
Item Description
References€ Displays the References dialog box for the current project,
Chapter 4
which lets you specify which object libraries and other VBA
projects the project should be able to access.
Additional Controls€ Displays the Additional Controls dialog box, which lets you add
more controls to the Toolbox.
Macros€ Displays the Macros dialog box, which lets you quickly select
and execute a macro from all open projects.
Options€ Displays the Options dialog box, which lets you set different
options for the Visual Basic Editor itself.
Properties€ Displays the Project Properties dialog box, which lets you set
several properties for the current project. The current project is
identified on the Menu as ProjectName Properties.
Digital Signature€ Displays the Digital Signatures dialog box, which allows you to
digitally sign your code using any digital signature you have
installed on your PC.

48
Part 2: Visual Basic for Applications