valadation list
 

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

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

valadation list
 

Thank you!!!

"Bernie Deitrick" wrote:

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