Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
option buttons | Excel Discussion (Misc queries) | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
option buttons help | Excel Worksheet Functions | |||
Option Buttons | Excel Discussion (Misc queries) | |||
yes/no option buttons | Excel Discussion (Misc queries) |