Cheatography
https://cheatography.com
Some handy keyboard shortcuts for the Excel VBA editor.
Ctrl + Letters
Ctrl+A |
Select all text in the current module. |
Ctrl+C |
Copies the selection to the clipboard. |
Ctrl+E |
Displays the (File > Export File) dialog box. |
Ctrl+F |
Displays the (Edit > Find) dialog box. |
Ctrl+G |
Displays the (View > Immediate window) window. |
Ctrl+H |
Displays the (Edit > Replace) dialog box. (Find/Replace) |
Ctrl+I |
Turn on quick information (Edit > Quick Info). |
Ctrl+J |
Displays a drop-down of available properties (Edit > List Properties/Methods). |
Ctrl+L |
Show the call stack (View > Call Stack). |
Ctrl+M |
Displays the (File > Import File) dialog box. |
Ctrl+N |
Inserts a new line and positions the cursor at the start of the line. Pressing Enter will maintain the same indentation. |
Ctrl+P |
Displays the (File > Print) dialog box. |
Ctrl+R |
Displays the (View > Project Explorer) window. |
Ctrl+S |
Saves (File > Save). |
Ctrl+T |
Displays the Components dialog box listing all the available components. This is a Visual Basic 6.0 dialog box. |
Ctrl+V |
Pastes the current clipboard entry. |
Ctrl+X |
Cuts the selection to the clipboard. |
Ctrl+Y |
Cuts the entire line to the clipboard. |
Ctrl+Z |
Undo the last action (Edit > Undo). |
|
|
Function Keys
F1 |
Stop code execution |
F2 |
Display Object Browser |
F3 |
Find next |
F4 |
Display Properties Window |
F5 |
Run currently selected code |
F6 |
Switch between split code windows |
F7 |
Displays code window |
F8 |
Step through code line by line |
F9 |
Insert or toggle break point |
F10 |
Toggles activation of menu bar |
Shift + Function
Shift+F2 |
Move to definition of procedure |
Shift+F3 |
Find previous occurrence of last search |
Shift+F4 |
Repeats last find (Find next) |
Shift+F7 |
Toggle between userform and userform's code |
Shift+F8 |
Step through code, and execute entire called procedure |
Shift+F9 |
Activate watch window |
Shift+F10 |
Display shortcut for menu for selected item |
|
|
Ctrl + Function
Ctrl+F2 |
Activates the Object Box in the top left corner of the Code window. |
Ctrl+F4 |
Closes the active MDI child window. |
Ctrl+F5 |
Runs the error handler code or returns the error to the calling procedure. Does not affect the setting for error trapping on the General tab. |
Ctrl+F6 |
Moves to the next open window. This is exactly the same as (Ctrl + Tab). |
Ctrl+F8 |
Run to the cursor. |
Ctrl+F9 |
Moves the current line of execution to the selection for the next executed command. |
Ctrl+F10 |
Activate the Menu bar. |
Other + Function
Alt+F4 |
Closes the Visual Basic Editor window and returns to the application. |
Alt+F5 |
Resume execution though the error handler / run error handler. |
Alt+F8 |
Steps into the error handler or returns the error to the calling procedure. Does not affect the setting for error trapping on the General tab of the Options dialog box. |
Alt+F11 |
Toggles between the Visual Basic Editor and the application. |
Ctrl+ Shift+F2 |
Moves back to the previous position (View > Last Position). |
Ctrl+ Shift+F8 |
Step out of code. |
Ctrl+ Shift+F9 |
Clear all breakpoints from the active project. |
|
Created By
Metadata
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets