View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
barry j barry j is offline
external usenet poster
 
Posts: 1
Default change the data validation to 'any value if 'other' is selected

When the user hits the 'other' option in my drop down box, I would like the
data validation to be reset to any value or a pop-up is displayed that allows
them to enter the correct data and I populate the cell and the data
validation allows it to take