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.
- Objective
- Function Keys
- Ctrl + Function Combination Keys
- Ctrl + Letter Combination Keys
- Shift + Function Combination Keys
- Alt + Function Combination Keys
- Alt + Letter Combination Shortcut Keys
- Ctrl + Shift + Function/Key Combination Shortcut Keys
- Other Shortcut Keys
- Video Tutorial
- Instructions to Run VBA Macro Code
- Other Useful Resources
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 | |
| 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