Help with Combo Box

C

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
 
A

aristotle

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

Regards,
A
 
C

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
 
D

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.)
 
Top