Cheatography
https://cheatography.com
Some handy keyboard shortcuts for the Excel VBA editor.
Ctrl + LettersCtrl+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 KeysF1 | 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 + FunctionShift+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 + FunctionCtrl+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 + FunctionAlt+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