Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List 27.08.08
I have a validation list for a particular cell. It contains a list of
longish phrases which I want to be able to select from for that particular cell. But after I have selected a particular phrase, I want to be able to amend it. It won't allow me to. I've tried including a blank line in the validation list, but that doesn't make any difference. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List 27.08.08
You cannot do that, since you need an element that exists in the list.
-- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "robzrob" wrote: I have a validation list for a particular cell. It contains a list of longish phrases which I want to be able to select from for that particular cell. But after I have selected a particular phrase, I want to be able to amend it. It won't allow me to. I've tried including a blank line in the validation list, but that doesn't make any difference. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List 27.08.08
If you want to amend it permanently you will have to do that in the source
list manually. If you want to amend it temporarily, turn off error alert in DV dialog and enter what you wish. This entry will not remain in the list. To add items to the list as you enter them you will need VBA code. See Debra Dalgleish's site for a sample workbook. http://www.contextures.on.ca/excelfiles.html#DataVal DV0012 - Update Validation List -- type a new value in a cell that contains data validation, and it's automatically added to the source list, and the list is sorted; a macro automates the list updates. DataValListAddSort.zip 11 kb Gord Dibben MS Excel MVP On Wed, 27 Aug 2008 14:43:33 -0700 (PDT), robzrob wrote: I have a validation list for a particular cell. It contains a list of longish phrases which I want to be able to select from for that particular cell. But after I have selected a particular phrase, I want to be able to amend it. It won't allow me to. I've tried including a blank line in the validation list, but that doesn't make any difference. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List 27.08.08
In xl2003, I'd use:
Data|Validation|Settings Tab List (and use a named range in the source box) But on the Error Alert tab, I'd uncheck the "Show error alert after invalid data is entered" box. robzrob wrote: I have a validation list for a particular cell. It contains a list of longish phrases which I want to be able to select from for that particular cell. But after I have selected a particular phrase, I want to be able to amend it. It won't allow me to. I've tried including a blank line in the validation list, but that doesn't make any difference. -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List 27.08.08
On Aug 28, 12:39*am, Dave Peterson wrote:
In xl2003, I'd use: Data|Validation|Settings Tab List (and use a named range in the source box) But on the Error Alert tab, I'd uncheck the "Show error alert after invalid data is entered" box. robzrob wrote: I have a validation list for a particular cell. *It contains a list of longish phrases which I want to be able to select from for that particular cell. *But after I have selected a particular phrase, I want to be able to amend it. *It won't allow me to. *I've tried including a blank line in the validation list, but that doesn't make any difference. -- Dave Peterson Thanks all. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel |