If you use the datavalidation it is not built in, you need a combobox from
the control toolbox

--
Regards,

Peo Sjoblom

(No private emails please)


"B9" wrote in message
...
I set up a drop down list in excel and wanted to know if there was a way to
set up a predictive text feature so that i don't have to scroll through
the
entire list to select the correct entry. i would like to be able to type
in
the first two letters and have the entry appear.