VBA code interpreter

[bop]

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.

 

[Juan Pablo González]

Haven't heard from it, haven't seen it anywhere either...

 

[adamleerich]

I think you are looking for the Intermediate window of the VB Editor.

 

[alansidman]

@adamleerich

The original post was from 19 years ago. Don't think the OP is still looking for an answer.

 

[Rick Rothstein]

The original post was from 19 years ago. Don't think the OP is still looking for an answer.

You don't know... the OP might have been checking every day, even multiple times a day, day after day for the last 19 years just hoping and hoping and hoping that someone would provide him with an answer.?

 

[adamleerich]

I guess I wasted my time replying to a thread started 19 years ago. Good thing you guys were at the ready to let me know the folly of my ways!