http://www.contextures.com/xlDataVal11.html

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Soni" wrote in message
...
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