Funnily enough I have just posted the same query.

However I found the reason why this was happening.
It is nothing to do with your settings, it is not working, because you have
IE open. Mine doesn't work either, but as soon as I shut down Internet
Explorer, (even in the middle of debugging some code), hey presto, the
variables are showing immediately.

Don't know why, but it works!!

HTH

Wild Jim


"Chip Pearson" wrote in message
...
In the VBA Editor, go to the Tools menu and 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


"Chet Shannon" wrote in message
...
I have Office 2003 and am writing some Excel VBA 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? (This is the only way
I
want to do it with the mouse because anything else much slower.)

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 4 times but no one has any ideas yet. Helllllp... any more ideas
on
getting it working to show the values on 'mouse-over' during single step
execution mode? Is there a program bug in Excel that someone is aware
of?
(Help MVP's..!)

Thanks,

Chet Shannon