I have a list of options to choose from in a drop down box but I want Excel
to auto complete the word - example: 911 hang-up - once I enter 9 I want
excel to fill in 911 hang-up rather than having to scroll down the list for
the answer.

Any help???

thanks,
Soni