validation list

[Guest]

hi
i have created a validation list with more then 500 name, but when i try to
find a particual name i have to go through all of them . is it possblie to
write the first alphabitic letter in the list and the drow down list will
point to that particual name e.g if the name in the list is Mark S. Mark can
i write only Ma to find all Names start with Ma

 

[Bob Phillips]

You can do this if you use a combobox from the control toolbox instead of
DV.

 

[Debra Dalgleish]

Data Validation doesn'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