It is my understanding that Excel 2002 has a VBA code intertreter. It displays a pop-up window of available options, arguments, valus, etc for the current object, property, procedure, etc. as you type in the code.
However, I can not get it to do this. It will show a box for the 1st object in a line of code (ie, Worksheets("sheet 1")). But it will not display for anything else.
I have checked under Tools|Options and "Auto List members" and "Auto Quick info" are checked.
Is there some other option I need to change to get this to work?
It is very helpful when typing in code. I have used it in Access VBA code.
However, I can not get it to do this. It will show a box for the 1st object in a line of code (ie, Worksheets("sheet 1")). But it will not display for anything else.
I have checked under Tools|Options and "Auto List members" and "Auto Quick info" are checked.
Is there some other option I need to change to get this to work?
It is very helpful when typing in code. I have used it in Access VBA code.