I was wondering if anyone had managed to use the auto expand function in
excel in the way that it is used in access. I would like to do this in a
combo box to filter aprox 1000 records that I have in the box.

you mean HFlexGrid...
NO way...Unless you're gonna do a whole lot of coding.
(and accept the distribution problems of licensed controls)

plenty of custom/semi FlexGrid controls out there (e.g.Igrid),
(BUT since VBA is uncompiled you'd still have the distribution problem


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

I was wondering if anyone had managed to use the auto expand function
in excel in the way that it is used in access. I would like to do
this in a combo box to filter aprox 1000 records that I have in the
box.

Could you tell me what a HFlexGrid is and how it is used???

"keepITcool" wrote:



you mean HFlexGrid...
NO way...Unless you're gonna do a whole lot of coding.
(and accept the distribution problems of licensed controls)

plenty of custom/semi FlexGrid controls out there (e.g.Igrid),
(BUT since VBA is uncompiled you'd still have the distribution problem


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

I was wondering if anyone had managed to use the auto expand function
in excel in the way that it is used in access. I would like to do
this in a combo box to filter aprox 1000 records that I have in the
box.

the activeX control used in Access
to browse hierarchical recordssets
(with the autoexpand/collapse feature)

unless you mean something different and we've got our wires crossed.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

Could you tell me what a HFlexGrid is and how it is used???

"keepITcool" wrote:



you mean HFlexGrid...
NO way...Unless you're gonna do a whole lot of coding.
(and accept the distribution problems of licensed controls)

plenty of custom/semi FlexGrid controls out there (e.g.Igrid),
(BUT since VBA is uncompiled you'd still have the distribution
problem


--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

I was wondering if anyone had managed to use the auto expand
function in excel in the way that it is used in access. I would
like to do this in a combo box to filter aprox 1000 records that
I have in the box.

What I am after is when I start to type in the box of the start of one on the
names in the field, that it automaticly goes to the first record with that
letter. Eg Bla clould go the the record of black if I hade a combo box full
of color names.

"keepITcool" wrote:

the activeX control used in Access
to browse hierarchical recordssets
(with the autoexpand/collapse feature)

unless you mean something different and we've got our wires crossed.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

Could you tell me what a HFlexGrid is and how it is used???

"keepITcool" wrote:



you mean HFlexGrid...
NO way...Unless you're gonna do a whole lot of coding.
(and accept the distribution problems of licensed controls)

plenty of custom/semi FlexGrid controls out there (e.g.Igrid),
(BUT since VBA is uncompiled you'd still have the distribution
problem


--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

I was wondering if anyone had managed to use the auto expand
function in excel in the way that it is used in access. I would
like to do this in a combo box to filter aprox 1000 records that
I have in the box.

see.. wires crossed!

it's not entirely similar
but have you played with following:

the properties of the combobox

Style = 2 fmStyleDropDownList
=just selection, no addition or "typing"
=this allows easy monitoring of the change event.

MatchRequired= true

MatchEntry= 1 fmMatchEntryComplete






--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

What I am after is when I start to type in the box of the start of
one on the names in the field, that it automaticly goes to the first
record with that letter. Eg Bla clould go the the record of black if
I hade a combo box full of color names.

"keepITcool" wrote:

the activeX control used in Access
to browse hierarchical recordssets
(with the autoexpand/collapse feature)

unless you mean something different and we've got our wires crossed.

--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

Could you tell me what a HFlexGrid is and how it is used???

"keepITcool" wrote:



you mean HFlexGrid...
NO way...Unless you're gonna do a whole lot of coding.
(and accept the distribution problems of licensed controls)

plenty of custom/semi FlexGrid controls out there (e.g.Igrid),
(BUT since VBA is uncompiled you'd still have the distribution
problem


--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Wesley Hickman wrote :

I was wondering if anyone had managed to use the auto expand
function in excel in the way that it is used in access. I
would like to do this in a combo box to filter aprox 1000
records that I have in the box.