The-Complete-Guide-To-VBA-Keyboard-Shortcuts 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.

Tab

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

Back Space

Deletes one character to the left of the cursor.

Enter

Create a new line

Insert

Toggle insert mode on or off

Delete

Deletes one character to the right of the cursor.

Home

Move the cursor to the beginning of the current line.

End

Move the cursor to the end of the current line.

Page Up

Move the viewable area of the module up one page

Page Down

Move the viewable area of the module down one page

Up

Move the cursor up one line

Down

Move the cursor down one line

Left

Move the cursor one character to the left

Right

Move the cursor one character to the right

F1

Open visual basic editor help

F2

Open the visual basic object browser

F3

Perform the Find Next command

F4

Open the Properies window

F5

Run the current procedure.

F6

Move the cursor between split windows

F7

Go to Code window

F8

Step into code
Equivalent to Debug > Step Into

F9

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

F10

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

Alt + A

Open the Add-Ins menu

Alt + D

Open the Debug menu

Alt + E

Open the Edit menu

Alt + F

Open the File menu

Alt + H

Open the Help menu

Alt + J

Open the Insert menu

Alt + O

Open the Format menu

Alt + Q

Close the visual basic editor.

Alt + R

Open the Run menu

Alt + T

Open the Tools menu

Alt + V

Open the View menu

Alt + W

Open the Window menu

Alt + F4

Close the visual basic editor.

Alt + F5

Run Error Handler

Alt + F6

Switch Between Last 2 Windows

Alt + F7

Step Error Handler

Alt + F11

Switch between the visual basic editor and Excel.

Alt + Tab

Cycle through all open Windows applications

Alt + Space Bar

Open visual basic editor system menu

Alt + Back Space

Undo the last command

Ctrl + A

Select all text in the current module

Ctrl + C

Copy the current selection

Ctrl + E

Export the currently selected module.

Ctrl + F

Open the Find dialog box

Ctrl + G

Open the Immediate window

Ctrl + H

Open the Replace dialog box

Ctrl + I

Display Quick Info for object selected

Ctrl + J

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

Ctrl + J

Bring object to front when creating a user form

Ctrl + K

Send object to back when creating a user form

Ctrl + L

Equivalent to View > Call Stack

Ctrl + M

Import a module file
Equivalent to File > Import Fileā€¦

Ctrl + N

Create a new line

Ctrl + P

Open the Print VBAProject dialog box

Ctrl + R

Open the Project window

Ctrl + S

Save the current project.

Ctrl + T

Open the Components dialog box

Ctrl + V

Paste the last item copied to your clipboard

Ctrl + W

Equivalent to Debug > Edit Watch

Ctrl + X

Cut the current selection

Ctrl + Y

Cut the entire current line

Ctrl + Z

Undo the last command

Ctrl + F2

Activate focus to the object selection drop down

Ctrl + F4

Close current window

Ctrl + F8

Equivalent to Debug > Run To Cursor

Ctrl + F9

Equivalent to Debug > Set Next Statement

Ctrl + F10

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

Ctrl + Tab

Cycle through all open visual basic windows

Ctrl + Space Bar

Auto complete current word

Ctrl + Back Space

Delete one word to the left of the cursor

Ctrl + Insert

Copy the current selection

Ctrl + Delete

Delete one word to the right of the cursor

Ctrl + Home

Move the cursor to the start of the current module

Ctrl + End

Move the cursor to the end of the current module

Ctrl + Page Up

Move the cursor to the start of the current procedure

Ctrl + Page Down

Move the cursor to the end of the current procedure

Ctrl + Up

Move the cursor to the previous procedure

Ctrl + Down

Move the cursor to the next procedure

Ctrl + Left

Move the cursor to the left by one word

Ctrl + Right

Move the cursor to the right by one word

Shift + F2

Go to variable declaration or object definition

Shift + F3

Find previous item from the cursor for the last item searched

Shift + F4

Find next item from the cursor for the last item searched

Shift + F8

Equivalent to Debug > Step Over

Shift + F9

Equivalent to Debug > Quick Watch

Shift + F10

Equivalent to right click to show menu

Shift + Tab

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

Shift + Insert

Paste the last item copied to your clipboard

Shift + Home

Select from the cursor to the start of the current line

Shift + End

Select from the cursor to the end of the current line

Shift + Page Up

Select from the cursor to the top of the module

Shift + Page Down

Select from the cursor to the bottom of the module

Shift + Up

Extend the current selection up one line

Shift + Down

Extend the current selection down one line

Shift + Left

Extend the current selection to the left by one character

Shift + Right

Extend the current selection to the left by one character

Ctrl + Shift + I

Equivalent to Edit > Parameter Info

Ctrl + Shift + J

Equivalent to Edit > List Constants

Ctrl + Shift + F2

Move the cursor to its previous position

Ctrl + Shift + F8

Equivalent to Debug > Step Out

Ctrl + Shift + F9

Equivalent to Debug > Clear All Breakpoints