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? |
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? |
All times are GMT +1. The time now is 05:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com