Like Data Validation BUT

J

JMay

Can i create something very similar to the Data Validation Drop Down,
EXCEPT -- be able to Edit the Choice made. I know it defeats the purpose,
But I need to give the User the Choice Jan-Dec (drop-down all 12 months),
but allow them every once in a while the ability to say EDIT to "Feb-A1",
when originally Feb was chosen from the drop-down. This is data-entry
and will span thousands of rows..

Thanks in advance
 
J

Jim Thomlinson

Do the data validation list exaclty as you would normally but go to the error
alert tab and uncheck the checkbox "Show error alert after invalid data has
been entered"

This will give you the drop down but will not throw any kind of error or
warning if the user free types.
 
J

JMay

Thanks VERY Much Jim


Jim Thomlinson said:
Do the data validation list exaclty as you would normally but go to the error
alert tab and uncheck the checkbox "Show error alert after invalid data has
been entered"

This will give you the drop down but will not throw any kind of error or
warning if the user free types.
 

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

Top