VBA Code to Reset Multiple DropDown Lists

[waterstone]

Hi, I have been reading through some of the other posts on creating a reset button for drop down lists and have not had any luck getting it to work. I could really use some help.

I have a worksheet that has 7 rows and 2 columns with dependent dropdowns with 45 different options. I am trying to create a "Reset Button" using a Command Button Active X Control.

I am good at excel but not familiar with VBA. I have had luck recording macros but in this case the worksheet has many dependent dropdowns so it would take a VERY long time to record all of the options.

Seems like it should be pretty simple, but no such luck.

the code Im using is

Private Sub CommandButton3_Reset()

Range("B10:C15").Value = “Please Select”

End Sub

Ive tried variations with functions "Reset_Dropdowns()" and "ResetDataVal()" all with the same range and value but not luck.

Any ideas would be appreciated.

Thanks in advance.

 

[Fluff]

What is wrong with the code you posted?