I have many check boxes, now I want to check them all in one time. How to do this
Z Zurn Sep 28, 2004 #1 I have many check boxes, now I want to check them all in one time. How to do this
G Guest Sep 28, 2004 #2 hi, lot of ways to do this you could put a label above the check boxes and put something like the folloning code behind it Private Sub Label1_Click() Me.CheckBox1 = True Me.CheckBox2 = True End Sub this is just one quick idea. tested. it works.
hi, lot of ways to do this you could put a label above the check boxes and put something like the folloning code behind it Private Sub Label1_Click() Me.CheckBox1 = True Me.CheckBox2 = True End Sub this is just one quick idea. tested. it works.
R Ron de Bruin Sep 28, 2004 #3 Hi Zurn If you use checkboxes from the Control toolbox Sub test2() For Each obj In ActiveSheet.OLEObjects If TypeOf obj.Object Is MSForms.CheckBox Then obj.Object.Value = True End If Next End Sub
Hi Zurn If you use checkboxes from the Control toolbox Sub test2() For Each obj In ActiveSheet.OLEObjects If TypeOf obj.Object Is MSForms.CheckBox Then obj.Object.Value = True End If Next End Sub
D Dave Peterson Sep 28, 2004 #4 And if you used checkboxes from the Forms toolbar (on a worksheet): ActiveSheet.CheckBoxes.Value = xlOn 'xlOff
And if you used checkboxes from the Forms toolbar (on a worksheet): ActiveSheet.CheckBoxes.Value = xlOn 'xlOff
