valadation list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Valadation 4
Excel 2000 Data Valadation, VLookUp, NameRange, with multiple crit 1
data - validation - list question 2
Data Valadation 5
Force Input when opening file 1
Drop Down List Question 5
Data Valadation 2
If statement propblem 4

Back
Top