9.2. Testing and debugging in VBA

All code needs to be tested and run against real-world data. Often, your tests will turn up errors. Debugging is the process of tracking down errors— mainly logic and runtime errors—by following the sequence in which code statements execute and monitoring the resulting changes in the values of your variables. VBA includes several tools that allow you to set the location where you want to start debugging and follow the variable values. These include:

• Breakpoints

• The Immediate window

• The Watch window and Quick Watch feature

• The Locals window

• The Call Stack