Hi Peter,

Data validation does not natively provide autocomplete functionality.

However, Debra Dalgleish provides a possible workaround, using a combobox,
at:

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


---
Regards,
Norman



"Peter" wrote in message
...
I want to select a text item from a long drop down list. Is there a way to
have a form of auto complete to help you search the list or do all methods
(eg: data,validation,list) require you to scroll up and down the list to
find
the entry you want?
Thanks.
--
Peter
London, UK