Resetting Option Buttons

Copper Contributor

Good morning,

I hope my query is simple, as I don't often build documents with buttons.

 

I have built a document with 6 groups of 3 buttons. What I would like is a "reset" button which resets each group so that the first option is selected. I inserted a command button and started with this code - on Click, which did not work:

 

Private Sub CommandButton1_Click()
ActiveSheet.Option_Button_1.Value = Yes
End Sub

 

If I figure out how to reset the first option button, I am confident I could get it to work for the other 5 I need to reset. Any help the community can provide is appreciated. 

 

0 Replies