Clearing Option Buttons

[pdaws]

I have four option buttons on a form that are not grouped. I would like to
be able to clear the buttons so that the user can select the appropriate
option button. I would also like to have all of the option button cleared
when the formed is reopened. This is not an active x control, but a from
control. I have tried different codes from the various discussions and none
of them address my particular issue. Please help.

 

[Harald Staff]

Hi

Assuming your Form is a worksheet, in fact assuming the very first
worksheet:

Sub ClearEm()
Dim i As Long
For i = 1 To Sheets(1).OptionButtons.Count
Sheets(1).OptionButtons(i).Value = False
Next
End Sub

HTH. Best wishes Harald

 

[pdaws]

Thanks Harold for the reply, but I tried it and it did not work. I put the
code at the end of the other codes of the option buttons and yes it is a
worksheet and it is worksheet 3.

 

[Harald Staff]

Ok, so either put it on worksheet 1 instead, or alter the code a little.

Hint: Look for the 1's

HTH. Best wishes Harald