VBA Keyboard shortcuts

Shortcut Meaning
Shift + F2 Place the cursor on any variable, procedure, or property and press Shift-F2 to jump to the items definition. If necessary this will open additional VBA modules in the VBA editor.
Ctrl+Shift+F2 Go back to where you came when you pressed [Shift F2]
F9 Set (or reset) a breakpoint to stop the program against the selected line of code.
F5 Run the current procedure (if it doesn’t require parameters)
F8 Run the current line.
Shift+F8 Step over the line by running the procedure on the current line without going into it and stepping through each line
Ctrl+Shift+F8 Continue - Run through the rest of the current procedure.
Ctrl+F9 Jump - Set the next statement to execute.


“In this age, which believes that there is a short cut to everything, the greatest lesson to be learned is that the most difficult way is, in the long run, the easiest” ~ Henry Valentine Miller

Copyright © SS64.com 1999-2017
Some rights reserved