This may sound stupid.....
 

.....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

--
anthonyenglis
-----------------------------------------------------------------------
anthonyenglish's Profile: http://www.excelforum.com/member.php...fo&userid=1530
View this thread: http://www.excelforum.com/showthread.php?threadid=26929

This may sound stupid.....
 

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"
wrote in message
...

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

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


--
anthonyenglish
------------------------------------------------------------------------
anthonyenglish's Profile:
http://www.excelforum.com/member.php...o&userid=15308
View this thread:
http://www.excelforum.com/showthread...hreadid=269291

This may sound stupid.....
 

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.

--

HTH

RP

"anthonyenglish" wrote in
message ...

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

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


--
anthonyenglish
------------------------------------------------------------------------
anthonyenglish's Profile:
http://www.excelforum.com/member.php...o&userid=15308
View this thread: http://www.excelforum.com/showthread...hreadid=269291

This may sound stupid.....
 

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

--

HTH

RP

"Chip Pearson" wrote in message
...
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"
wrote in message
...

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

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


--
anthonyenglish
------------------------------------------------------------------------
anthonyenglish's Profile:
http://www.excelforum.com/member.php...o&userid=15308
View this thread:
http://www.excelforum.com/showthread...hreadid=269291