This may sound stupid.....

[anthonyenglish]

.....but it's driving me nuts.

I have just moved to Excel 2003 from 97. In 97 when I pointed my mous
to a variable (when stepping through a macro) I would get details of th
value the variable is holding at that instance. In 2003 it doesn'
appear. Is this normal? The only way I seem to be able to get th
value at any point in time is to use the debug window. Is there
setting that I have to check to get this 'featuer' back

 

[Chip Pearson]

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


"anthonyenglish" <[email protected]>
wrote in message
news:[email protected]...

 

[Bob Phillips]

Anthony,

Not sure of the cause, I've lost IntelliSense on my laptop, but you can also
get the value by selecting the variable and Shift-F9.

 

[Bob Phillips]

Thanks Chip, got my IntelliSense back, Auto List Items (sic!).