Creating an Autoexpand in Excel Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 :
 
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 :
 
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.
 
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 :
 
The first and lat lines of your code seem to come up with an error.

Any idea why this could be???
 
CODE?.. what code?
just the manual setting of properties in the designer.

--
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.
 
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 :
 
No worries, Thanks for all your help. Wes

keepITcool said:
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 :
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SOLVED! Allow Autocorrect is the culprit when caps lock fouls up AutoExpand in combo boxes 0
combo box 2
Autofilter on a combo box 2
Combo box in user form 5
refreshing combo box in form? 1
Combo Box autoexpand not working. 7
Why does Autoexpand in combo box not work with accented characters? 4
Having trouble with combo boxes. 11

Back
Top