O'Reilly logo

Business Solutions VBA for the 2007 Microsoft Office System by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required