validation list
 

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

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

--
HTH

Bob Phillips

"osaka78" wrote in message
...
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

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


osaka78 wrote:
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


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