software

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

www.contextures.com/xlDataVal11.html

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Soniquot; gt; wrote in message
...
gt;I have a list of options to choose from in a drop down box but I want Excel
gt; to auto complete the word - example: 911 hang-up - once I enter 9 I want
gt; excel to fill in 911 hang-up rather than having to scroll down the list
gt; for
gt; the answer.
gt;
gt; Any help???
gt;
gt; thanks,
gt; Soni