Thread: valadation list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default valadation list

Chris,

Just turn off the error alert (see that tab), and any entry will be accepted, while still offering
the drop-down list as an entry aid.

HTH,
Bernie
MS Excel MVP


"Chris" wrote in message
...
I have a valadation list set up in Excell 2000. Is it possible to allow the
end user to edit one of the choices. In the list I have the choice "OTHER"
and I would like them to be able to expand on that. Thanks