VBA Macro to clear selected dropdown cells to blank (Keeping conditional formatting in place)

[mjaeger1]

Hi All,

I have a worksheet that will serve as the basis for many future projects, and will be used over and over again.

I would like to have a button (VBA macro) to "reset" all previous dropdown box selections to the original format (no data selected) but keeping all formatting and conditional formatting in place.

Is there a way to "clear all fields" for the selected data? ( the dropdown boxes are scattered throughout, so i would need to only "clear" certain ranges.


How can this be done?

 

[Joe4]

Using:

Range(myRange).ClearContents

should only erase the values and not the formatting.

 

[mjaeger1]

Using:

Range(myRange).ClearContents

should only erase the values and not the formatting.

Thanks @Joe4! Worked like a charm!

 

[Joe4]

You are welcome.