How show value of variable by mouse-over in debug single step mode

[Guest]

I have Office 2003 and am writing some code. My question is how do I get
the value of a variable to show up when I move the mouse cursor on top of
that variable while single stepping through code?

Previously this worked and I'm now single stepping through my code to debug
it and the variables are not displaying their values when I move the mouse
cursor over them. I know I can add a 'watch' also but this is inconvenient
to do on-the-fly. Tools / auto data tips is turned on also.

So it worked before and now it's not doing it. I don't know why. I've
posted 3 times but no one has any ideas yet. Helllllp... any more ideas?

Thanks,

 

[Guest]

Chet,
Two options: (1)
Have you tried

debug.print YourVarName

in your code, immediately after your variable? To use it, you would have to
have your Immediate window enabled. Or,

(2) Enable your debug toolbar in the VBA IDE, highlight the variable then
click on the quick watch button on the toolbar, that is, the one with the
glasses icon.

HTH,
Ben

 

[Guest]

Anyone know how to actually fix this so the value of the variable will
display on mouse-over in debug mode? I've happily gotten a few work-arounds
and alternate methods but no fix yet. Should I try the 'detect & repair'
that Office 2003 has possibly?

Thanks, Chet

 

[Chip Pearson]

In the VBA editor, go to the Tools menu, choose Options, then the
Editor tab. There, ensure that 'Auto Data Tips' is checked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message

 

[Guest]

Hi Chip,
I do have this box checked and it has been checked, but still no display of
variable values on mouse-over.

Thx Chet

 

[Guest]

Hi Chip,
I do have this box checked and it has been checked, but still no display of
variable values on mouse-over.

Thx Chet

 

[Guest]

Hi Chip,
I do have this box checked and it has been checked, but still no display of
variable values on mouse-over.

Thx Chet

 

[Edward Ulle]

The value can be displayed only when the sub or function is inscope. If
the variable is in a sub or function out of scope no value is displayed.

 

[Guest]

I think the value is inscope because there is only one sub and no
sub-routines or jumping around. All values are 'present' (right word?) in
the current sub I'm coding. Plus the value won't show in any of my code.
It's not limited to just one sub. Thx Chet

 

[Guest]

Any more ideas on fixing this? Thx ! Chet

 

[Edward Ulle]

Chet,

Sorry the Auto Data Tips and inscope are the things I'm aware of.

You say your single stepping through the code. So you are in the
subroutine containing the highlighted line of code and no values are
displayed. That is the module inscope.