DEBUGGING ONE STEP AT A TIME

To work through some debugging situations, you need to be able walk a program line by line while it's executing. VBA provides four Step commands to accomplish this: Step Into, Step Over, Step Out, and Run to Cursor. You can use these commands after a program halts execution by choosing the appropriate command from the Debug menu.

Note

All four step commands skip over the same type lines of code that don't allow breakpoints: comments, declaring variables (the Dim statement), blank lines, and line labels or line numbers.

Stepping into Code Line by Line

The Step Into command steps through code lines one by one. When a code line has a call to another procedure, the editor then follows the code into it. This includes ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.