Keep Drop Down/ Data Validation with Macro

Katie - Sep 21, 2016 at 05:53 PM
 Blocked Profile - Sep 21, 2016 at 06:15 PM
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!

1 response

Blocked Profile
Sep 21, 2016 at 06:15 PM
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.