Excel Macros: Shortcut Keys for Debugging Code

By Michael Alexander

Part of Excel Macros For Dummies Cheat Sheet

What to Press on Your Keyboard 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