valadation list

C

Chris

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
 
B

Bernie Deitrick

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
 
C

Chris

Thank you!!!

Bernie Deitrick said:
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
Click to expand...
 
Top