Excel Macros: Shortcut Keys for Debugging Code

Excel Sales Forecasting For Dummies

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

About This Article

About the book author:

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.