Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |