Excel Checkbox Clearing

[gotgame0314]

I have a sheet with checkboxes that were placed from the contro
toolbox. Is there a way to clear all the checkboxes on the sheet usin
a command button

Thank

 

[Norman Jones]

Hi GotGame,

Try assigning the following code to the command button:

'=============>>
Sub Tester01()
Dim Ctl As OLEObject

For Each Ctl In Worksheets("Sheet1").OLEObjects
If TypeOf Ctl.Object Is MSForms.CheckBox Then
Ctl.Object.Value = False
End If
Next Ctl
End Sub
'<<=============


---
Regards,
Norman



"gotgame0314" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

Or just use it as:

Sub CommandButton1_Click()
(still under that same worksheet)