Show Menu
Cheatography

Excel VBA Editor Keyboard Shortcuts by

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/­Rep­lace)
Ctrl+I
Turn on quick inform­ation (Edit > Quick Info).
Ctrl+J
Displays a drop-down of available properties (Edit > List Proper­tie­s/M­eth­ods).
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 indent­ation.
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 compon­ents. 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 applic­ation.
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 applic­ation.
Ctrl+ Shift+F2
Moves back to the previous position (View > Last Position).
Ctrl+ Shift+F8
Step out of code.
Ctrl+ Shift+F9
Clear all breakp­oints from the active project.
           
 

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          Sublime Text 2 Windows Keyboard Shortcuts
          Wikipedia Cheat Sheet
          VBA for Excel Cheat Sheet