O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition by John Green, Stephen Bullen, Dennis Wallentin, Rob Bovey

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

Chapter 16. VBA Debugging

Debugging is the most important and probably the least understood aspect of programming. No one writes perfect code on the first try. Being able to efficiently locate and correct the mistakes you’ve made is a significant part of what separates a great programmer from a skilled amateur. In this chapter we demonstrate how to use the built-in debugging features of the Visual Basic Editor (VBE) to locate and correct bugs in your code as well as provide tips and techniques that will help you become a better debugger.

Basic VBA Debugging Techniques

Run Mode Versus Break Mode

A running application can exist in one of two states. Run mode is exactly what its name suggests. The application is running normally. In break mode an application ...

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