Hi all,
I have recently started working for another Co and
am already coding in Excel VBA. I used to use Excel 97 and there was
feature that would list the constants as I typed the code but now I a
using ExcelXP (2002) and I cannot find how to turn this feature on..
can anyone give me a point in the right direction ?
Thanks in advance,
Craig...

--
Message posted from http://www.ExcelForum.com

in the vbe under tools=Option, in the editor tab, look in code settings.
Check the Auto options.

--
Regards,
Tom Ogilvy


"MBison " wrote in message
...
Hi all,
I have recently started working for another Co and
am already coding in Excel VBA. I used to use Excel 97 and there was a
feature that would list the constants as I typed the code but now I am
using ExcelXP (2002) and I cannot find how to turn this feature on...
can anyone give me a point in the right direction ?
Thanks in advance,
Craig....


---
Message posted from http://www.ExcelForum.com/

Thanks for your feedback guys.
Checked that options tab, all the checkboxes are checked except Requir
Variable declaration. Any ideas

--
Message posted from http://www.ExcelForum.com

Can you be a bit clearer on what you are not getting that you expect,
please.

Are you saying that if you type (for instance)

msgbox "hello",

you don't get an intellisense list of constants?

MBison < wrote:
Thanks for your feedback guys.
Checked that options tab, all the checkboxes are checked except Require
Variable declaration. Any ideas ?


---
Message posted from http://www.ExcelForum.com/

OK.... for example, if i'm coding and I write

Columns("K:K").

as soon as I hit the period, I would expect a list of options... shoul
I start typing what i'd like.. say R, ( for

Columns("K:K").Replace


) then the list cuts down to the R options, like a combo box. This i
the Auto quick info option I believe. That option IS checked and I hav
closed down excel and started it again but the feature is still no
enabled. I'm wondering if there is a reference I need to register i
order for this feature to work

--
Message posted from http://www.ExcelForum.com

OK.... for example, if i'm coding and I write

Columns("K:K").


What happens if you try with

Range("K:K").

?

some objects don't have intellisense, for some reason known by MS...

--
Regards,

Juan Pablo González

I don't get a dropdown in that case either.

What happens if you type:

Dim rng As Range
Set rng = Columns("K:K")
rng.


MBison < wrote:

OK.... for example, if i'm coding and I write

Columns("K:K").

as soon as I hit the period, I would expect a list of options... should
I start typing what i'd like.. say R, ( for

Columns("K:K").Replace


) then the list cuts down to the R options, like a combo box. This is
the Auto quick info option I believe. That option IS checked and I have
closed down excel and started it again but the feature is still not
enabled. I'm wondering if there is a reference I need to register in
order for this feature to work ?


---
Message posted from http://www.ExcelForum.com/

Is there some reference I need to install in order to get this feature
The help files have already been installed and work fine.....

--
Message posted from http://www.ExcelForum.com

In the VB Editor under Tools | Options, there is a slew of things t
check or uncheck. Not sure exactly what you are not seeing, but tha
is probably the place to look.



--
Message posted from http://www.ExcelForum.com