Like Data Validation BUT
 

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

Like Data Validation BUT
 

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

Jim Thomlinson


"JMay" wrote:

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

Like Data Validation BUT
 

Thanks VERY Much Jim


"Jim Thomlinson" wrote:

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

Jim Thomlinson


"JMay" wrote:

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