VBA Keyboard Shortcuts
Part of the 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 window |
| 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 |
