Business Solutions VBA for the 2007 Microsoft Office System

16Debugging VBA Procedures

IN THIS CHAPTER

A Basic Strategy for Debugging

Pausing a Procedure

Stepping Through a Procedure

Monitoring Procedure Values

Using the Immediate Window

Debugging Tips

It’s usually easy to get short Sub and Function procedures up and running. However, as your code grows larger and more complex, errors inevitably creep in. Many of these errors—programmers call them bugs—are simple syntax problems you can fix easily, but others will be more subtle and harder to find. For the latter—whether the errors are incorrect values being returned by functions or problems with a procedure’s overall logic—you’ll need to be able to look “inside” your code to scope out what’s wrong. The good news is that VBA gives you several ...