Chet,
I am no MVP by a long shot, but I had the same problem as you today and
here's how I got the value of the variable to appear when I move my cursor
over it.

-Open up your code in the VB editor
-Press F9 where you want your breakpoints
-Press F5 to run your code
-When it stops at a breakpoint you put your cursor over a variable to get
the value
-Press F5 to resume running your code until the next breakpoint

Here is the webpage that gave me this information:
http://pubs.logicalexpressions.com/P...cle.asp?ID=349

Hope that helps you out,
Bill

"Chet Shannon" wrote:

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