Data Validation dropdown lists don't support autocomplete. If you can
use programming, there are instructions here for adding a combobox from
which you can select one of the values from the data validation list. In
the combobox, you can enable autocomplete:

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

ratt wrote:
I am using data validation on a cell and using a list of option ( part
names etc...) and wish to know if there is an option that a user can
start to type in a name of the part and the cell would automatically go
to the first possible option..i.e the use types in the letter p and the
part processor will show up...or power supply when the next letter s
type)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html