Shortcut Keys for Debugging Code in Visual Basic Editor

By John Walkenbach

Part of Excel VBA Programming For Dummies Cheat Sheet

Debugging your code is an important part of working with Excel Macros. Although there are ways to use the debugging features through the Visual Basic Editor menu options, you may find these keyboard shortcuts to be a much more efficient way to debug your code.

What to Press What It Does
F5 Runs the current procedure or continues after pausing.
Ctrl+Break Halts the currently running procedure.
F8 Goes into debug mode and executes one line at a time.
Ctrl+F8 Executes code up until the cursor.
Shift+F8 Steps over the current line while in debug mode.
F9 Toggles a breakpoint for the currently selected line.
Ctrl+Shift+F9 Clears all breakpoints.
Alt+D+L Compiles the current Visual Basic project.