Viewing variables in Debug

[Bill]

From time-to-time, I've needed to examine the
current value of variables not available in the
current code display while in Debug, i.e.,
holding the cursor over the variable name as it
appears in code. If there's some form of the
object browser where I can examine variables
within the scope of the current module, I've not
been able to find it.

What's the secret?

Thanks,
Bill

 

[Bill]

I found it.
Thanks,
Bill

 

[Banana]

I found it.
Thanks,
Bill

You know, it may be nice to post what you found so others could benefit
from what you learned. I'm guessing you either discovered the Watch or
using Immeidate windows to do ad hoc interrogation of various properties
not available via hover-over, which is common when wanting to examine
objects' properties as opposed to examining a value stored in a
variable, for example.

 

[Bill]

Ah yes, I'm in too much of a hurry today multi-plexing
amongst more things than I have time for.

One can find a useful discussion of the use of Debug
and the Immediate Window in VBA at:

http://www.cpearson.com/excel/Debug.htm

Bill

 

[Stuart McCall]

Ah yes, I'm in too much of a hurry today multi-plexing
amongst more things than I have time for.

One can find a useful discussion of the use of Debug
and the Immediate Window in VBA at:

http://www.cpearson.com/excel/Debug.htm

Bill

<snip

I notice he neglects to mention 'Quick Watch', which you achieve by
highlighting what you want to know the contents of, then pressing Shift-F9.
I find this really useful when debugging.