View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Clearing Option Buttons

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.