View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wigi Wigi is offline
external usenet poster
 
Posts: 396
Default 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.