Autocomplete? Recollect Debra Dalgleish once posted:

.. Although data validation doesn't support autocomplete, there's a sample
file here that provides 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/excelfiles.html

Under 'Data Validation', look for:
DV0043 - Data Validation Combobox With Entry Check
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
I have a long list of names in the validation database, so scrolling through
the entire list takes a long time.

Is there a way to set up the name find so that as a user starts to type in
the first letters of a name it automatically goes to the right name?

For example if they type "M", it goes to first name starting with "M"; and
if they continue "ME" it goes to first name starting with "ME"?

If basic Excel does not have this feature, do you know of any add-ins or
third party additions that cover this feature?
--
Richard