Enabling help on code

M

MBison

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...
 
K

kkknie

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.
 
T

Tom Ogilvy

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

MBison

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

MBison

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

Steve Garman

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?
 
M

MBison

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
 
J

Juan Pablo González

OK.... for example, if i'm coding and I write
Columns("K:K").
Click to expand...

What happens if you try with

Range("K:K").

?

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

Steve Garman

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.
 
M

MBison

Juan said:
*> OK.... for example, if i'm coding and I write

What happens if you try with

Range("K:K").

?

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

BINGO !!!! Coding it that way does trigger the auto help feature
Strange how it would'nt work the other way I coded it, which was lifte
from the help example anyway.
Thanks everyone for your input
 
Top