I have a very simple excel spreadsheet in which I have two option buttons captioned "Yes" and "No". I have tried to create some VB code so that based upon which button is initially selected, a macro button will perform a specified task when pressed. The code is very basic and listed below.
Private Sub OptionButtonYes_Click()
If OptionButtonYes.Value = True Then
When I try to run it I keep getting the error message:
Run-time error '424':
I have tried to fix this myself but have not been able to. Could you please assist?