» » SHORTCUT KEYS FOR DEBUGGING CODE IN VISUAL BASIC EDITOR

SHORTCUT KEYS FOR DEBUGGING CODE IN VISUAL BASIC EDITOR

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 PressWhat It Does
F5Runs the current procedure or continues after pausing.
Ctrl+BreakHalts the currently running procedure.
F8Goes into debug mode and executes one line at a time.
Ctrl+F8Executes code up until the cursor.
Shift+F8Steps over the current line while in debug mode.
F9Toggles a breakpoint for the currently selected line.
Ctrl+Shift+F9Clears all breakpoints.
Alt+D+LCompiles the current Visual Basic project.
Subscribe to: Post Comments (Atom)