Data Validation

[hshayhorn]

If I have a list of choices is there a way for the user to type in part of
one of the choices and the rest of the choice would auto fill? For example if
one of the choices is Purple and the users types in pur could the cell know
to select Purple as the choice?

 

[Dave Peterson]

Not using data|validation.

If I have a list of choices is there a way for the user to type in part of
one of the choices and the rest of the choice would auto fill? For example if
one of the choices is Purple and the users types in pur could the cell know
to select Purple as the choice?

 

[Max]

Debra Dalgleish shows a way to "build in" the AutoComplete feature into DVs,
which finds matching items in the list as you start to type ..
http://www.contextures.com/xlDataVal10.html
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,500 Files:362 Subscribers:59
xdemechanik