Microsoft Office Tutorials and References
In Depth Information
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,
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.
Search JabSto ::




Custom Search