| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Lists
Hi All
I want to create a data validation list which allows the user to select either an option in the list or allows them to enter they own data. Is that possible? Thanks for your help, Silena |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation Lists
In the data validation dialog box, go to the Error Alert tab
Remove the check mark from 'Show error alert after invalid data is entered.' Click OK Silena K-K wrote: Hi All I want to create a data validation list which allows the user to select either an option in the list or allows them to enter they own data. Is that possible? Thanks for your help, Silena -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation Lists
Thanks Debra - that's excellent!!
"Debra Dalgleish" wrote: In the data validation dialog box, go to the Error Alert tab Remove the check mark from 'Show error alert after invalid data is entered.' Click OK Silena K-K wrote: Hi All I want to create a data validation list which allows the user to select either an option in the list or allows them to enter they own data. Is that possible? Thanks for your help, Silena -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| Data Validation - Using 2 Lists | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Data Validation (2 lists) | Excel Discussion (Misc queries) | |||
| Data Validation with Lists | Excel Discussion (Misc queries) | |||
Linear Mode
