Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation query
*computer crashed when submitting this message last time so may be on twice*
Is it possible to have a blank entry within a validation list, that you can then enter "other" information in outside the list? eg. I have a validation list that contains names but sometimes I need to put in a name outside the list and can't? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation query
Yes, just add the list as normal, but on the error tab in DV, check the
Ignore errors box. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "katet" wrote in message ... *computer crashed when submitting this message last time so may be on twice* Is it possible to have a blank entry within a validation list, that you can then enter "other" information in outside the list? eg. I have a validation list that contains names but sometimes I need to put in a name outside the list and can't? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation query | Excel Worksheet Functions | |||
Data Validation Query | Excel Discussion (Misc queries) | |||
MS Query from Excel - Preserving formatting, validation and Commen | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) |