VBA Keyboard Shortcuts - dummies

By John Paul Mueller

Part of VBA For Dummies Cheat Sheet

If you’re using VBA to streamline your Windows programs and operations, making use of the shortcut keys in the following list can help you streamline even more quickly and easily.

Press To Do This Press To Do This
Alt+F11 Open the VBA editor F1 Get help on any selected item
Alt+F8 Display a list of macros F2 Display the Object Browser window
Ctrl+Break Perform an emergency stop of the program F4 Display the Properties window
Ctrl+G Display the Immediate window F5 Start the program
Ctrl+I List the quick information for the selected element F7 Display the Code window after selecting a form or control
Ctrl+J List the properties and methods for an object F9 Add a breakpoint
Ctrl+R Display Project Explorer Shift+F7 Display the form that corresponds to the active Code
Ctrl+Shift+I List the parameter information for the selected element Shift+F9 Add a quick watch for the highlighted text
Ctrl+Shift+J List the constants associated with an enumeration Ctrl+Tab Move to the next Code or UserForm window