YasserKhalil
08-05-2010, 02:21 AM
Hi everybody
I found a code which works fine for the checkboxes from ActiveX Controls..
The code
Sub UntickCheckBoxesControls()
Dim I As Long
For I = 1 To 4
ActiveSheet.OLEObjects("CheckBox" & I).Object.Value = False
Next I
End Sub
I tried to apply it on checkboxes from Form Controls
Any help about that..I'd be appreciate
I found a code which works fine for the checkboxes from ActiveX Controls..
The code
Sub UntickCheckBoxesControls()
Dim I As Long
For I = 1 To 4
ActiveSheet.OLEObjects("CheckBox" & I).Object.Value = False
Next I
End Sub
I tried to apply it on checkboxes from Form Controls
Any help about that..I'd be appreciate