Connecting Tech Pros Worldwide Help | Site Map

Debugging in VBA - 2G) The Watch Pane

NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,672
#1   May 20 '07
Table of Contents - [Debugging in VBA]
Previous Chapter - [Debugging in VBA - 2F) The Locals Pane]
Next Chapter - [Debugging in VBA - 3] General Tips]
-----------------------------------------------------------------------------------------------
2G) The Watch Pane.
This allows you to view various variables and/or objects/properties as the code progresses. This can also be used to show results of calculations and even to cause the code to stop when certain conditions are met.

If there is a variable (even a property of an object) that is not immediately visible in the Locals Pane, then pretty well anything can be displayed here. It can also cause a breakpoint when a variable contains a particular value, or even changes its value. This can prove very helpful when something turns out wrong but you don't know where it's being changed in the code.
Attached Thumbnails
vbawatch.jpg  



Reply