change the data validation to 'any value if 'other' is selected

B

barry j

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
 
Top