How to use the Watch Window as a Power Programming Tool

[SkipVought]

How to use the Watch Window as a Power Programming Tool faq707-4594

Please check this out and post your feedback.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[VBAjedi]

Skip,

A much-needed and very valuable topic. Some suggestions on areas that could be more descriptive for the sake of those who have never seen this technique:

1) Generically speaking, what should someone put into their "simple sub" (i.e. include code that refers to the object you want to explore).
2) Right-click what? (The object in the code window you wish to explore)
3) Where does it tell me all this information? (In the object browser window which, by the way, you need to open if for some reason it isn't already open)

Other than that - good stuff! I learned about this technique far too late in my opinion. It could have saved me much time if I had discovered it about a year before I did!

VBAjedi

 

[SkipVought]

VBA,

Thanx for the feedback. I'll tune it up over the next few days.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[LazyMe]

Just out of curiostity; Did you actually use the watch window for the purpose of finding if an object has certain properties/methods?

If so, then why not simply use the object browser for this?

Greetings,
Rick

 

[SkipVought]

Sure. I could use Help, or the Object Browser.

But in the Watch Window, I can see actual values within a particular object that corresponds to my test set. I can use this in conjunction with Break Points if I need to inspect my code under specific conditions.



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com