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.