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?
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?