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

VBA Keyboard Shortcut Key Sequence Guide

Click here to learn more about pressing the shortcuts and using a Laptop keyboard

There are two ways to press the shortcut keys depending on the separator character used in the sequence.

+ Plus

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.

, Comma

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.

Laptop Keyboards

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.

Running Macros & Code

These shortcuts help when you are running your macros or stepping through each line of code to test and debug.

ShortcutWindowsMac
Jump between Excel and the VB Editor WindowAlt+F11Opt+F11 or Fn+Opt+F11
Run Macro/ProcedureF5F5
Step Through Each Line of CodeF8Cmd+Shift+i
Run to CursorCtrl+F8
Add a Break PointF9
Reset/stop codeAlt,R,R
Compile VBA ProjectAlt,D,L

Navigating Through Code Modules & Procedures

These shortcuts will help you jump between procedures (macros) and quickly navigate through code module windows.

ShortcutWindowsMac
Flip through open code windowsCtrl+TabCtrl+Tab
Flip backwards through open code windowsCtrl+Shift+TabCtrl+Shift+Tab
Jump to Definition (procedure name that text cursor is in)Shift+F2
Jump to last positionCtrl+Shift+F2
Jump to previous/next procedureCtrl+Page Up/DownFn+Ctrl+Cmd+↑ or ↓
Select the entire procedureCtrl+Shift+Page DownFn+Ctrl+Cmd+Shift+↓
Find WindowCtrl+FCmd+F
Replace WindowCtrl+HCmd+Shift+H

Writing Code

These shortcuts help save time when writing code with tasks like autocompleting words, deleting lines, showing the Intellisense menu, and more.

ShortcutWindowsMac
Complete WordCtrl+SpaceCtrl+Space
Delete entire lineCtrl+YCmd+Y
Jumps to the beginning or end of a wordCtrl+← or →Cmd+←or →
Selects the entire wordCtrl+Shift+→ or ←Cmd+Shift+→ or ←
List properties/methods (Intellisense drop-down list)Ctrl+JCmd+J
Quick InfoCtrl+iCmd+i

VB Editor Windows

Open the windows and task panes that are commonly used within the VB Editor.

ShortcutWindowsMac
Immediate WindowCtrl+GCtrl+Cmd+G
Project Explorer WindowCtrl+RCtrl+Cmd+R
Properties WindowF4
Insert a new code moduleAlt,I,M
Insert a new userformAlt,I,U
View userform codeF7
Object BrowserF2Ctrl+Cmd+B

Download the PDF File

Get a printable PDF version of this page, plus our Excel Shortcuts Guide with over 270 Excel Shortcuts.

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.

Comments

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!

>