101+ Excel VBA Keyboard Shortcuts

Visual Basic Editor

This is the complete list of visual basic keyboard shortcuts. Some of these will be very familiar like Ctrl + C and Ctrl + V will still copy and paste repectively. But some are quite different than their Excel counterpart, for example Ctrl + Y will not redo the undone command but instead will cut the entire line of code at the cursors current position.

Add one level of indentation to a highlighted block of code.

Deletes one character to the left of the cursor.

Create a new line

Toggle insert mode on or off

Deletes one character to the right of the cursor.

Move the cursor to the beginning of the current line.

Move the cursor to the end of the current line.

Move the viewable area of the module up one page

Move the viewable area of the module down one page

Move the cursor up one line

Move the cursor down one line

Move the cursor one character to the left

Move the cursor one character to the right

Open visual basic editor help

Open the visual basic object browser

Perform the Find Next command

Open the Properies window

Run the current procedure.

Move the cursor between split windows

Go to Code window

Step into code
Equivalent to Debug > Step Into

Toggle code breakpoints on or off
Equivalent to Debug > Toggle Breakpoint

Activate focus on the menu bar. Select different menu headings with left or right keys and open a menu with the down key.

Open the Add-Ins menu

Open the Debug menu

Open the Edit menu

Open the File menu

Open the Help menu

Open the Insert menu

Open the Format menu

Close the visual basic editor.

Open the Run menu

Open the Tools menu

Open the View menu

Open the Window menu

Close the visual basic editor.

Run Error Handler

Switch Between Last 2 Windows

Step Error Handler

Switch between the visual basic editor and Excel.

Cycle through all open Windows applications

Open visual basic editor system menu

Undo the last command

Select all text in the current module

Copy the current selection

Export the currently selected module.

Open the Find dialog box

Open the Immediate window

Open the Replace dialog box

Display Quick Info for object selected

Show a list of available properties or methods
Equivalent to Edit > List Properties/Methods

Bring object to front when creating a user form

Send object to back when creating a user form

Equivalent to View > Call Stack

Import a module file
Equivalent to File > Import File…

Create a new line

Open the Print VBAProject dialog box

Open the Project window

Save the current project.

Open the Components dialog box

Paste the last item copied to your clipboard

Equivalent to Debug > Edit Watch

Cut the current selection

Cut the entire current line

Undo the last command

Activate focus to the object selection drop down

Close current window

Equivalent to Debug > Run To Cursor

Equivalent to Debug > Set Next Statement

Activate focus on the menu bar. Select different menu headings with left or right keys and open a menu with the down key.

Cycle through all open visual basic windows

Auto complete current word

Delete one word to the left of the cursor

Copy the current selection

Delete one word to the right of the cursor

Move the cursor to the start of the current module

Move the cursor to the end of the current module

Move the cursor to the start of the current procedure

Move the cursor to the end of the current procedure

Move the cursor to the previous procedure

Move the cursor to the next procedure

Move the cursor to the left by one word

Move the cursor to the right by one word

Go to variable declaration or object definition

Find previous item from the cursor for the last item searched

Find next item from the cursor for the last item searched

Equivalent to Debug > Step Over

Equivalent to Debug > Quick Watch

Equivalent to right click to show menu

Remove one level of indentation from a highlighted block of code.

Paste the last item copied to your clipboard

Select from the cursor to the start of the current line

Select from the cursor to the end of the current line

Select from the cursor to the top of the module

Select from the cursor to the bottom of the module

Extend the current selection up one line

Extend the current selection down one line

Extend the current selection to the left by one character

Extend the current selection to the left by one character

Equivalent to Edit > Parameter Info

Equivalent to Edit > List Constants

Move the cursor to its previous position

Equivalent to Debug > Step Out

Equivalent to Debug > Clear All Breakpoints