Help with Combo Box

[cfriedberg]

I currently use Excel 2000, and have a list of names. I would like t
create a combo box that would allow the user to either find the name b
scrolling through or by typing in the first few letters of the name.
When I create the combo box on the worksheet using the forms button fo
combo box, it doesn't allow me to type in the first few letters. an
help appreciated. charle

 

[aristotle]

Hi, have you considered using validation? Does it have to be a combo
box?

Regards,
A

 

[cfriedberg]

what do you mean by 'validation'? I still need a lookup function

 

[cfriedberg]

I looked up validation, and I understand, however, the list I would b
referencing would be over 1,000 items long, and would grow throug
time, so the ability to type in the first few letters of the item s
that the list would pare down to only relevant items is crucial. Ca
this be done in validation? I don't see where. Thanks

 

[Dave Peterson]

Make sure you used the combobox from the control toolbox toolbar.

I'd set the style to: fmstyledropdownlist
and change the matchentry to: fmmatchentrycomplete

While in design mode--also an icon on that control toolbox toolbar, right click
on the combobox and select properties and you'll find these settings.

(Data|Validation doesn't support this.)