control combo box - type a letter - goes to that name

[Judi]

I have a control combo box. It has been loaded with data
and the drop down works.

I want to be able to type a letter in the combobox and it
goes to the item that starts with that letter. If I type
a second letter, I want it to narrow it down to the item
that best fits.

I wrote in yesterday and someone told me to set
ListIndex,by right clicking on the combo box and
selecting Properties. I did that and I cannot find
ListIndex anywhere.

I am using Excel 2000. I hope someone can help me. Thanks
in advance.

 

[Bob Phillips]

Hi Judi,

You need the Control toolbox combobox for this sort of functionality.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

I am using the control toolbox for the combobox - and I
have the data loaded into it. I can see and pick the data
in the drop down. But if I type a letter, the box goes
blank and the down arrow disappears. ??????

 

[Dave Peterson]

Show the control toolbox toolbar.
click on the design mode icon
click on your combobox
right click|properties.

Look for MatchEntry. Change it to: 1-fmmatchentrycomplete

You may also want to change Style to: 2-fmstyledropdownlist
if the user should only get to choose--not type in anything new.

 

[Judi]

Combobox from Control toolbar
Properties are:
ListFillRange A1:A9 (A1 is blank the rest has data)
Linked Cell is A15 (this is a blank cell)
MatchEntry: 1-
Style 2-
ListRows - 9

The first time I did this it went to the correct data when
I typed in the first letter then it stopped working. Now
if I tab to the combo box and type a letter, the combo box
goes blank (down arrow disappears) and I see only the
letter I typed.

This is making me crazy. I need this for work and I can't
make it work. I've tried everything I can think of. Can
you help?

 

[Dave Peterson]

I didn't have a linked cell when I tried it. When I added the linked cell, it
didn't work as nice (not even close!).

Maybe you can dump the linked cell and just put that portion in code.

Double click on that combobox (while in design mode) and paste this in:

Option Explicit
Private Sub ComboBox1_Change()
Me.Range("a15").Value = Me.ComboBox1.Value
End Sub

(actually, just paste that me.range line into the procedure that excel created
for you.)