Cancel Optionbutton in excel form

[becshu]

Hi,
Is there a way to set an optionbutton so if you click on it a second time it is no longer checked. I have yes and no option buttons, but I can only uncheck the yes by checking the no. I simply want to be able to uncheck one of the buttons so they both can stay blank.
Thanks!

 

[PBAPaul]

Use two check boxes instead.

You can set one check box to be "yes" and the other to be "no".

When you initiate the form you could, if you wished, to set the check boxes to default values.

Private Sub UserForm_Initialize()
 With Me
  .CheckBox1.Value = True
  .CheckBox2.Value = False
 End with
End Sub

Hope that this helps.