Clearing Option Buttons
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" wrote:
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" wrote in message
...
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.
|