This documentation is archived and is not being maintained.

Standard Toolbar

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.


Contains buttons that are shortcuts to some commonly used menu items.

You can click a toolbar button once to carry out the action represented by that button. You can select the Show ToolTips option in the General tab of the Options dialog box if you want to display ToolTips for the toolbar buttons.

Gg264785.tbr_dgwa_ZA01201698(en-us,office.14).gifView <host application>

Toggles between the host application and the active Visual Basic document.


Opens a menu so that you can insert one of the following objects to your active project. The icon changes to the last object you added. The default is the form.

Gg264785.tbr_ufrm_ZA01201759(en-us,office.14).gif — UserForm


Gg264785.tbr_cmod_ZA01201688(en-us,office.14).gifClass Module

Gg264785.tbr_proc_ZA01201726(en-us,office.14).gif — Procedure

Gg264785.tbr_save_ZA01201736(en-us,office.14).gifSave <host document name>

Saves the host document including the project and all of its components — forms and modules.


Removes the selected control or text and places it on the Clipboard.


Copies the selected control or text onto the Clipboard.


Inserts the contents of the Clipboard at the current location.


Opens the Find dialog box and searches for the specified text in the Find What box.

Gg264785.tbr_undo_ZA01201762(en-us,office.14).gifUndo <last editing action>

Reverses the last editing action.

Gg264785.tbr_redo_ZA01201734(en-us,office.14).gifRedo <last editing action>

Restores the last text editing Undo actions if no other actions have occurred since the last Undo.

Gg264785.tbr_strt_ZA01201751(en-us,office.14).gifRun Sub/UserForm or Run Macro

Runs the current procedure if the cursor is in a procedure, runs the UserForm if a UserForm is currently active, or runs a macro if neither the Code window nor a UserForm is active.


Stops execution of a program while it's running and switches to break mode.

Gg264785.tbr_end_ZA01201701(en-us,office.14).gifReset <project>

Clears the execution stack module level variables and resets the project.

Gg264785.tbr_dsgm_ZA01201699(en-us,office.14).gifDesign Mode

Turns design mode off and on.

Gg264785.tbr_pexp_ZA01201722(en-us,office.14).gifProject Explorer

Displays the Project Explorer, which displays a hierarchical list of the currently open projects and their contents.

Gg264785.tbr_prop_ZA01201727(en-us,office.14).gifProperties Window

Opens the Properties window so you can view the properties of the selected control.

Gg264785.tbr_obbr_ZA01201718(en-us,office.14).gifObject Browser

Displays the Object Browser, which lists the object libraries, the type library, classes, methods, properties, events, and constants you can use in code, as well as the modules and procedures you defined for your project.


Displays or hides the Toolbox which contains all of the controls and insertable objects (such as a Microsoft Excel Chart) available to your application. This is only available when a UserForm is active.

Gg264785.tbr_ahlp_ZA01201669(en-us,office.14).gifMicrosoft Visual Basic for Applications Help

Opens the help viewer for the associated application..