Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stupid | New Users to Excel | |||
Stupid | Excel Worksheet Functions | |||
Stupid | Setting up and Configuration of Excel | |||
Stupid | Links and Linking in Excel | |||
Stupid | Charts and Charting in Excel |