Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please help, I have designed a simple spreadsheet that
uses Check Boxes and Option Buttons from the Control Toolbox and I am trying to make a small VBA routine to clear them all. I thought I could use: Sub Clear_cb_ob() Dim cb As CheckBox Dim ob As OptionButton For Each cb In Sheet1 cb.Value = False Next For Each ob In Sheet1 ob.Clear Next End Sub But I just get: Object doesn't support this property or method |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide Group Boxes Around Option Buttons | Excel Worksheet Functions | |||
Check Boxes or Option Buttons | Excel Discussion (Misc queries) | |||
option buttons or check boxes | New Users to Excel | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Forms: Group Boxes and Option Buttons | Excel Programming |