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

--



"Chet Shannon" wrote:

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,

--
Chet Shannon