Keep Drop Down/ Data Validation with Macro Closed

Question

Hello, I searched around a lot and could not find an answer to this:

I need to replace values in a cell with a macro while keeping the "Data Validation"/ List drop down the same. Is this possible? Each time I tried to use a macro to make the cell value "", it took away the data validation. 

Would much appreciate help on this! 
Best, 
Katie

ac3mark · Answer

Are you using a macro, or VBA?

If you are using VBA, then after you set the value, reinitialize the Validation though a call to subroutine that reestablishes the said validation.

Keep Drop Down/ Data Validation with Macro

1 response

Similar discussions

Subscribe To Our Newsletter!