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?

Data Validation
 

Not using data|validation.



hshayhorn wrote:

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

Data Validation
 

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
---
"hshayhorn" wrote:
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?