valadation list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 11 Jul 2007 12:50 GMT

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

Reply to this Message

Bernie Deitrick - 11 Jul 2007 15:58 GMT

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

>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

Reply to this Message

Chris - 11 Jul 2007 19:24 GMT

Thank you!!!

> Chris,
>
[quoted text clipped - 8 lines]
> > 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

Reply to this Message

Rate this thread: