VBA Keyboard Shortcuts List
This page contains a list of my top 25 shortcuts for VBA and the VB Editor, including shortcuts for the Windows, and Mac versions of Excel/Office. You can download a printable PDF version of the list below.
How to Press the Shortcut Keys
There are two ways to press the shortcut keys depending on the separator character used in the sequence.
The + (plus) between keys means press & hold the keys together in order. For example, to press the shortcut Ctrl+Shift+L to Toggle Filters, you will:
Press & hold Ctrl, then press & hold Shift, then press L. Then release all keys.
The , (comma) between keys means press & release each key in order. For example, to press the shortcut Alt,E,S to open Paste Special, you will:
Press & release Alt, then press & release E, then press & release S.
If you are using a laptop keyboard then you might be limited on the some of the shortcuts you can press. Laptop keyboards tend to have smaller keyboards and don't always contain keys like Page Up, Page Down, Menu, etc.
You might also need to press the Fn (function) key in combination with the function keys F1 to F12. Some laptops have Fn Lock Mode so that you don't have to press Fn with the the function keys.
Checkout our post on the Best Keyboards for Excel Keyboard Shortcuts to learn more.
How to Use & Search This Page
The shortcuts are divided into different sections based categories of where the shortcut is used.
The Table of Contents in the right sidebar can be used to navigate to each section of the page. You can also press Ctrl+F to open your browser's Find box in the top-right corner of the browser window. Then type a search to find a specific shortcut you are looking for. You can leave a comment at the bottom of the page with any questions or suggestions.
The shortcuts are divided into different sections based categories of where the shortcut is used (cells, worksheets, workbooks, etc.). Some sections have additional sub sections based on different actions/tasks (navigating, writing formulas, formatting, etc.).
The Table of Contents below can be used to navigate to each section of the page. You can also use your browser's Find box (found in the settings of Chrome and Safari) to find a specific shortcut you are looking for. Please leave a comment at the bottom of the page with any questions or suggestions.
Download the PDF Version
Click the link below to get a free printable PDF version of this page with over 25 VBA Shortcuts.
VBA Keyboard Shortcuts List.pdf (338 KB)
Running Macros & Code
These shortcuts help when you are running your macros or stepping through each line of code to test and debug.
|Jump between Excel and the VB Editor Window||Alt+F11||Opt+F11 or Fn+Opt+F11|
|Step Through Each Line of Code||F8||Cmd+Shift+i|
|Run to Cursor||Ctrl+F8|
|Add a Break Point||F9|
|Compile VBA Project||Alt,D,L|
Navigating Through Code Modules & Procedures
These shortcuts will help you jump between procedures (macros) and quickly navigate through code module windows.
|Flip through open code windows||Ctrl+Tab||Ctrl+Tab|
|Flip backwards through open code windows||Ctrl+Shift+Tab||Ctrl+Shift+Tab|
|Jump to Definition (procedure name that text cursor is in)||Shift+F2|
|Jump to last position||Ctrl+Shift+F2|
|Jump to previous/next procedure||Ctrl+Page Up/Down||Fn+Ctrl+Cmd+↑ or ↓|
|Select the entire procedure||Ctrl+Shift+Page Down||Fn+Ctrl+Cmd+Shift+↓|
These shortcuts help save time when writing code with tasks like autocompleting words, deleting lines, showing the Intellisense menu, and more.
|Delete entire line||Ctrl+Y||Cmd+Y|
|Jumps to the beginning or end of a word||Ctrl+← or →||Cmd+←or →|
|Selects the entire word||Ctrl+Shift+→ or ←||Cmd+Shift+→ or ←|
|List properties/methods (Intellisense drop-down list)||Ctrl+J||Cmd+J|
VB Editor Windows
Open the windows and task panes that are commonly used within the VB Editor.
|Project Explorer Window||Ctrl+R||Ctrl+Cmd+R|
|Insert a new code module||Alt,I,M|
|Insert a new userform||Alt,I,U|
|View userform code||F7|
Download the PDF File
Get a printable PDF version of this page, plus our Excel Shortcuts Guide with over 270 Excel Shortcuts.
Check out our Excel Shortcuts Guide that contains over 270 mouse and keyboard shortcuts for the Windows, Mac, and Web versions of Excel.
Please leave a comment below with suggestions for any shortcuts we missed, or ways to improve this page. We will continue to update the page based on your feedback. Thanks!