waterstone
New Member
- Joined
- Feb 25, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
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.
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.