View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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