Macro or VBA Code to un tick CheckBox

[Guest]

Dear All,

I have few checkbox at one tab of spreadsheet that assigned with few macro
if I tick that Checkbox.

Now, If I want to untick all that "ticked" Checkbox automatically by using
Macro/vba code, is there any vba code that I can use ?

I try to use macro recording to untick those checkbox, but it does not work.

Highly Appreciate for any comment and help,

Thansk alot,

PA

 

[Leith Ross]

Dear All,

I have few checkbox at one tab of spreadsheet that assigned with few macro
if I tick that Checkbox.

Now, If I want to untick all that "ticked" Checkbox automatically by using
Macro/vba code, is there any vba code that I can use ?

I try to use macro recording to untick those checkbox, but it does not work.

Highly Appreciate for any comment and help,

Thansk alot,

PA

Hello PA,

Here are 2 macros to do the job. The first macro is for Control
Toolbox CheckBoxes, like the ones on a UserForm, and the Excel
Worksheet only Forms Checkboxes.

'Begin Macro Code...
Sub ClearCheckBoxes1()

' This macro clears all Control Toolbox CheckBoxes on the
ActiveSheet
Dim CB As Object

For Each CB In ActiveSheet.OLEObjects
If TypeName(CB.Object) Like "CheckBox" Then
CB.Object.Value = ""
End If
Next CB

End Sub

Sub ClearCheckBoxes2()

' This macro clears all Forms CheckBoxes on the ActiveSheet
Dim CB As Object

For Each CB In ActiveSheet.CheckBoxes
CB.Value = xlOff
Next CB

End Sub
'End Macro Code

Sincerely,
Leith Ross

 

[Guest]

Dear Leith,

Thanks you very much for your help.It does work well

Best Regards

PA