| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation
Hi,
I'm validating a cell, using Name range, I have 5 items and a blank. I don't know if I'm trying to do something that Excel won't allow. I need users to select from the given items, without being able to override those items, but at the same time I need a blank for users to add a new item if necessary. Is this possible? As always, any light you can give me is highly appreciated. Thanks. Regards, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Validation
Select the cell you wish to validate..........
Data Validation SettingsTab Allow: select LIST "Myriam" wrote: Hi, I'm validating a cell, using Name range, I have 5 items and a blank. I don't know if I'm trying to do something that Excel won't allow. I need users to select from the given items, without being able to override those items, but at the same time I need a blank for users to add a new item if necessary. Is this possible? As always, any light you can give me is highly appreciated. Thanks. Regards, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Validation
Sorry, hit the SEND button too soon.........
should be.... Data Validation SettingsTab Allow: select LIST Source: select your list plus one blank cell OK Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Select the cell you wish to validate.......... Data Validation SettingsTab Allow: select LIST "Myriam" wrote: Hi, I'm validating a cell, using Name range, I have 5 items and a blank. I don't know if I'm trying to do something that Excel won't allow. I need users to select from the given items, without being able to override those items, but at the same time I need a blank for users to add a new item if necessary. Is this possible? As always, any light you can give me is highly appreciated. Thanks. Regards, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Validation
Thanks Chuck.
Regards, "CLR" wrote: Sorry, hit the SEND button too soon......... should be.... Data Validation SettingsTab Allow: select LIST Source: select your list plus one blank cell OK Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Select the cell you wish to validate.......... Data Validation SettingsTab Allow: select LIST "Myriam" wrote: Hi, I'm validating a cell, using Name range, I have 5 items and a blank. I don't know if I'm trying to do something that Excel won't allow. I need users to select from the given items, without being able to override those items, but at the same time I need a blank for users to add a new item if necessary. Is this possible? As always, any light you can give me is highly appreciated. Thanks. Regards, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Validation
Happy to help..........thanks for the feedback.
Vaya con Dios, Chuck, CABGc3 "Myriam" wrote: Thanks Chuck. Regards, "CLR" wrote: Sorry, hit the SEND button too soon......... should be.... Data Validation SettingsTab Allow: select LIST Source: select your list plus one blank cell OK Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Select the cell you wish to validate.......... Data Validation SettingsTab Allow: select LIST "Myriam" wrote: Hi, I'm validating a cell, using Name range, I have 5 items and a blank. I don't know if I'm trying to do something that Excel won't allow. I need users to select from the given items, without being able to override those items, but at the same time I need a blank for users to add a new item if necessary. Is this possible? As always, any light you can give me is highly appreciated. Thanks. Regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation | Excel Worksheet Functions | |||
| Data validation with hyperlinks | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
Linear Mode
