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 | |
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 funciton 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 |
Back to Tutorial
You may also like to read other VBA tutorial articles.