Standard Toolbar

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.


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.

tbr_dgwa_ZA01201698 View <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.

tbr_ufrm_ZA01201759 — UserForm


tbr_cmod_ZA01201688Class Module

tbr_proc_ZA01201726 — Procedure

tbr_save_ZA01201736 Save <host document name>

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

tbr_cut_ZA01201694 Cut

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

tbr_copy_ZA01201692 Copy

Copies the selected control or text onto the Clipboard.

tbr_pste_ZA01201730 Paste

Inserts the contents of the Clipboard at the current location.

tbr_find_ZA01201703 Find

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

tbr_undo_ZA01201762 Undo <last editing action>

Reverses the last editing action.

tbr_redo_ZA01201734 Redo <last editing action>

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

tbr_strt_ZA01201751 Run 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.

tbr_brk_ZA01201682 Break

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

tbr_end_ZA01201701 Reset <project>

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

tbr_dsgm_ZA01201699 Design Mode

Turns design mode off and on.

tbr_pexp_ZA01201722 Project Explorer

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

tbr_prop_ZA01201727 Properties Window

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

tbr_obbr_ZA01201718 Object 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.

tbr_tbx_ZA01201755 Toolbox

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.

tbr_ahlp_ZA01201669 Microsoft Visual Basic for Applications Help

Opens the help viewer for the associated application..