Report

Keep Drop Down/ Data Validation with Macro

Ask a question Katie - Latest answer on Sep 21, 2016 06:15PM
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
See more 
Helpful
+0
moins plus
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.
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!