Help with debugging

C

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!
 
C

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?
 
C

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!
 
C

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)
 
C

Capt. Bangs

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Debugging 1
Debugging Advice Wanted 7
Problem disabling double click event 1
Debugging: how to see entire string var value? 6
How to see value of UDT variable while single-stepping? 1
Function Description 1
Displaying value of variable when debugging when cursor on variabl 2
Debugging Help 1

Top