VBA code interpreter

bop · May 11th, 2002, 09:13 AM

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 · May 13th, 2002, 12:37 AM

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

May 13th, 2002, 12:37 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Haven't heard from it, haven't seen it anywhere either... __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 11th, 2002, 09:13 AM	#1
bop New Member Join Date: Apr 2002 Posts: 12	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.