Creating an Autoexpand in Excel Combo Box
 

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.

Creating an Autoexpand in Excel Combo 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.

Creating an Autoexpand in Excel Combo 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.

Creating an Autoexpand in Excel Combo 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.

Creating an Autoexpand in Excel Combo 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.

Creating an Autoexpand in Excel Combo 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.

Creating an Autoexpand in Excel Combo Box
 

The first and lat lines of your code seem to come up with an error.

Any idea why this could be???

"keepITcool" wrote:

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.

Creating an Autoexpand in Excel Combo Box
 

CODE?.. what code?
just the manual setting of properties in the designer.

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


Wesley Hickman wrote :

The first and lat lines of your code seem to come up with an error.

Any idea why this could be???

"keepITcool" wrote:

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.

Creating an Autoexpand in Excel Combo Box
 

There is no properties in this combo box, only a format controll box that
does not have these properties that you said to change. My version of excel
is 2000.

"keepITcool" wrote:


CODE?.. what code?
just the manual setting of properties in the designer.

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


Wesley Hickman wrote :

The first and lat lines of your code seem to come up with an error.

Any idea why this could be???

"keepITcool" wrote:

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.

Creating an Autoexpand in Excel Combo Box
 

Wesley,

In excel you can insert "plain" comboboxes from the "forms" toolbar.
But you can also insert an msforms.combobox from the "control toolbox"
toolbar.

I assumed you were talking about the second, which has different
functionality than the native excel combobox.

Just experiment a little.

so sorry.
I'm signing off... it;s getting late here..

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


Wesley Hickman wrote :

There is no properties in this combo box, only a format controll box
that does not have these properties that you said to change. My
version of excel is 2000.

Creating an Autoexpand in Excel Combo Box
 

No worries, Thanks for all your help. Wes

"keepITcool" wrote:

Wesley,

In excel you can insert "plain" comboboxes from the "forms" toolbar.
But you can also insert an msforms.combobox from the "control toolbox"
toolbar.

I assumed you were talking about the second, which has different
functionality than the native excel combobox.

Just experiment a little.

so sorry.
I'm signing off... it;s getting late here..

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


Wesley Hickman wrote :

There is no properties in this combo box, only a format controll box
that does not have these properties that you said to change. My
version of excel is 2000.