Debug VBA Code
BREAKPOINT
A selected program line at which execution automatically stops.
To add a breakpoint click the right grey margin within the Procedure at the point the execution should stop.
DEBUG
To debug macros see Immediate Window, Watch Window or Locals Window in the VBA help.
To quickly debug macros place your mouse insertion point anywhere in the Procedure and step-through using F8. Each line will be highlighted yellow as you step through. You can make changes and then drag the yellow highlight up/down to repeat/omit lines.
You can hover your mouse pointer over variables etc and see their values.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| Excel Data Tables |
| Data Validation |
| Excel Date & Time Calculations |
| Return The Weekday of Date in Excel |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Gallery
