Command Button w/ VBA code to reset Data Validation dropdown lists & manual entry cells

Hi all,

I have a spreadsheet (let's call it "Sheet AA") with multiple Data Validation dropdown lists. I want to insert a Command Button that will reset all of my dropdown lists to the first option on each list (for example, "Select Option").

On the same spreadsheet, I also have multiple cells that require manual value entries. I wish to reset all these cells to blank with the same Command Button.

Is it possible to do this with a single click of the Command Button?

I have zero experience using Command Buttons and Macros/VBA so please be as specific as possible in your explanation and let me know if you require any further information.

For simplicity, let's assume my dropdown lists are in cells (D21, D23, D25, F21, F23, F25) and my manual entry cells are (I21, I23, I25).

Thank you in advance!

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.