Standard Visual Basic Editor Shortcut Keys

By John Walkenbach

Part of Excel VBA Programming For Dummies Cheat Sheet

As you work with Visual Basic Editor, you may want to navigate the windows using keyboard shortcuts instead reaching for the mouse. These short cuts allow you to navigate the Visual Basic Editor interface.

What to Press What It Does
Alt+F11 Toggles between the VBE and Excel windows.
Shift+F10 Displays the active window’s shortcut menu (replicates right-clicking).
Ctrl+R Opens Project Explorer.
F4 Opens the Properties window.
F2 Opens Object Browser.
F1 Opens VBA Help.
F7 Activates the open module window.