16Debugging VBA Procedures

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 ...

Get Business Solutions VBA for the 2007 Microsoft Office System 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.