Keep Drop Down/ Data Validation with Macro

Closed

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!
Best,
Katie

Keep Drop Down/ Data Validation with Macro
Display two columns in data validation list but return only one - Guide
Tmobile data check - Guide
Spell number in excel without macro - Guide
Transfer data from one excel worksheet to another automatically - Guide
Macro excel download - Download - Spreadsheets

1 response

Answer 1 / 1

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.

Similar discussions

AMD data change update new data to DMI

Unlock safe folder without losing any data

How To Fix Mint Mobile Data Not Working?

Hosted app data will not clear

Similar discussions

Subscribe To Our Newsletter!