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
|