Use a Combo Box which has Autocomplete.

See Debra Dalgleish's site for more.

http://www.contextures.on.ca/xlDataVal10.html




On 17 Apr 2007 11:38:29 -0700, " wrote:

Hey all,

I have a drop down list which contains names of 3,200+ companies. I
used the menu option Data, Validation, and Allow List and point to
cell AP2:AP3225 for the company list. Now, is there any way for me to
type in the first few letters of the company name in the drop down
list to allow that company (or companies) to appear first.

For example, I'm looking for Prudential, I'll type Pru, and the drop
down list will start at the first entry for Pru on the list. I hope I
was clear in this explanation. Please help - if further clarification
is needed, please let me know.

Thanks in advance...