VBA Keyboard Shortcut keys

VBA Editor Keyboard Shortcut Keys List

VBA Editor Keyboard Shortcut Keys Complete List helps to fasten process in visual basic editor. These keys works for standard U.S. English keyboards. If it is non U.S. English keyboards the shortcut keys are little different.
Let us how to use keyboard keys as VBA editor shortcut keys.

The following are complete list of VBA editor keyboard shortcut keys list and its performed action.

Function Keys:

Here are the function keys used in the VBA editor window as shortcut keys.

Shortcut Key Action Performed
F1 Microsoft Visual Basic for Applications Help/td>
F2 Object Browser
F3 Find
F4 Properties Window
F5 Runs the current procedure
F6 Split between two code Windows
F7 Code window
F8 Step into code line by line
F9 Breakpoint
F10 Activates Menu Bar

Ctrl + Function Combination Keys:

Here are the Ctrl + Function combination keys which are used in the VBA editor window.

Shortcut Key Action Performed
Ctrl + F2 Focus To Object Box
Ctrl + F4 Close the active child code Window
Ctrl + F6 Go to the next open window
Ctrl + F8 Run To Cursor
Ctrl + F10 Activate Menu Bar

Ctrl + Letter Combination Keys:

Here are the Ctrl + Letter combination keys which are used in the VBA editor window.

Shortcut Key Action Performed
Ctrl + A Select All Text
Ctrl + C Copy
Ctrl + E Export Module
Ctrl + F Find
Ctrl + G Immediate Window
Ctrl + H Replace
Ctrl + I Turn On Quick Information
Ctrl + J List Properties/Methods/Members
Ctrl + L Show Call Stack
Ctrl + M Import File
Ctrl + N New Line
Ctrl + P Print
Ctrl + R Project Explorer
Ctrl + S Save
Ctrl + T Show All Available Available Components
Ctrl + V Paste
Ctrl + X Cut
Ctrl + Y Cut Entire Line
Ctrl + Z Undo

Shift + Function Combination Keys:

Here are the Shift + Function combination keys used in the VBA editor window.

Shortcut Key Action Performed
Shift + F2 Procedure Definition
Shift + F3 Find Previous
Shift + F4 Find Next
Shift + F8 Execute Procedure at a time
Shift + F9 Quick Watch
Shift + F10 Show Right Click Menu

Alt + Function Combination Keys:

Here are the Alt + Function combination keys used in the VBA editor window.

Shortcut Key Action Performed
Alt + F4 Close VBE
Alt + F5 Run Error Handler
Alt + F11 Toggles between VBE and Application

Alt + Letter Combination Shortcut Keys:

Here are the Alt + Letter Combination Shortcut Keys used in the VBA editor window.

Shortcut Key Action Performed
Alt + A Add-Ins Menu
Alt + D Debug Menu
Alt + E Edit Menu
Alt + F File Menu
Alt + H Help Menu
Alt + I Insert Menu
Alt + O Format Menu
Alt + Q Closes the Visual Basic Editor and Return to Application
Alt + R Run Menu
Alt + T Tools Menu
Alt + V View Menu
Alt + W Window Menu

Ctrl + Shift + Function/Key Combination Shortcut Keys:

Here are the Ctrl + Shift + Function/Key combination Shortcut Keys which are used in the VBA editor window.

Shortcut Key Action Performed
Ctrl + Shift + F2 Previous/Last Position
Ctrl + Shift + F8 Step out of procedure/code
Ctrl + Shift + F9 Clear All Breakpoints
Ctrl + Shift + I Turn On parameter information
Ctrl + Shift + J Displays Available List Constants

Other Shortcut Keys:

Here are the other Keys which are used in the VBA editor window.

Shortcut Key Action Performed
Insert Toggle Insert Mode
Delete Deletes right side character of the cursor
Backspace Deletes left side character of the cursor
Tab Indents the current line
Enter New Line
Home Moves to the beginning of the current line
End Moves to the end of the current line
Page Up Moves one screen upwards
Page Down Moves one screen downwards
Left Arrow← Moves left one character
Right Arrow→ Moves right one character
Up Arrow↑ Moves up one line
Down Arrow↓ Moves down one line
Ctrl + Home Moves to the top of the module
Ctrl + End Moves to the bottom of the module
Ctrl + Page Up Moves to the top of the current procedure
Ctrl + Page Down Moves to the start of the next procedure
Ctrl + Left Arrow Moves one word to the left
Ctrl + Right Arrow Moves one word to the right
Ctrl + Up Arrow Moves to the sub or function directly above
Ctrl + Down Arrow Moves to the sub or function directly below
Ctrl + Break Stops execution
Ctrl + Insert Copy selection to Clipboard
Ctrl + Enter Enters a New Line/Carriage Return
Ctrl + Delete Delete To End Of Word
Ctrl + Spacebar Turn On Complete Word
Ctrl + Backspace Delete To Start Of Word
Ctrl + Tab Moves to the next module
Shift + Tab Un-indent the current line
Shift + Insert Paste the current clipboard
Shift + Home Selects to the start of the line
Shift + End Selects to the end of the line
Shift + Page Up5 Selects to the top of the module
Shift + Page Down6 Selects to the bottom of the module
Shift + Left Arrow← Extends the selection one character to the left
Shift + Right Arrow→ Extends the selection one character to the right
Shift + Up Arrow↑ Extends the selection up one line
Shift + Down Arrow↓ Extends the selection down one line
Ctrl + Shift + F2 Previous/Last Position
Ctrl + Shift + F8 Step out of procedure/code
Ctrl + Shift + F9 Clear All Breakpoints
Ctrl + Shift + I Turn On parameter information
Ctrl + Shift + J Displays Available List Constants
Alt + Spacebar Activates System Menu
Alt + Backspace Undo the last action
Alt + Tab Moves to the next application

Video Tutorial

You can also watch this tutorial at YouTube.

Instructions to Run VBA Macro Code or Procedure:

You can refer the following link for the step by step instructions.

Instructions to run VBA Macro Code

Other Useful Resources:

Click on the following links of the useful resources. These helps to learn and gain more knowledge.

VBA Tutorial VBA Functions List VBA Arrays in Excel Blog

VBA Editor Keyboard Shortcut Keys List VBA Interview Questions & Answers

Leave a Reply