Auto complete in a validation list

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

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" <Soni@discussions.microsoft.com> wrote in message
news:29850900-6CAD-48DF-879A-71AB7B4A44BE@microsoft.com...
>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