Help with debugging

[Capt. Bangs]

Previously, when I was writing segments of VBA code and ran the debugger
using the step-through functionality, I could see the values that had already
been assigned to variables by the code if I hovered the cursor over a
variable name. Now I'm working in VBA and that hover/reveal functionality
doesn't seem to be available. Is there a setting I need to adjust in order
to get this to be available?

Thanks!

 

[Capt. Bangs]

I think I answered my own question: the variables have to be declared as
"Public" in order for the hover/reveal functionality to work. Is that right?

 

[Capt. Bangs]

Well, that worked temporarily, but once again, I'm unable to see the values
of the variables and/or ranges that are being referenced. Help!

 

[Chip Pearson]

In VBA, go to the Tools menu, Options, and ensure that "Auto Data Tips" is
checked on the Editor tab.


Nope. It should work for locals as well as globals.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Capt. Bangs]

Thanks, Chip. I think that this option was checked, but now it seems to be
working fine. Go figure! Thanks again.