View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default 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