Excel VBA Programming For Dummies
Book image
Explore Book Buy On Amazon
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.

About This Article

This article is from the book:

About the book author:

Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.

This article can be found in the category: