In VBA, 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


"Wild_Jim" wrote in message
...
Thanks for this, but my option was already ticked.
I have tried various approaches, but I cannot get the thing to
work at tun time. Any more ideas? - It really is a pain not
being able to see the values of variables - Im currently adding
a watch, but that is not as easy.

"Nick Hodge" wrote in
message ...
Jim

'Show tooltips' under toolsoptionsgeneral in the VBE
controls this (Alt+F11)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Wild_Jim" wrote in message
...
I have just upgraded to Excel 2003 and when I use the debugger
to "step through" a program, I can no longer hover over
variables to see their values - is there an option to turn
this on?

Thanks in advance.