Hi,
I could really do with some help. I'm creating a timesheet for work where a user clicks on a check box which only selects the checkboxs for weekdays in a month. At the moment it auto selects everyday. This is the code I'm using to select all the checkboxs at once:
"Sub CheckBox1_Click()
Dim CB As CheckBox
For Each CB In ActiveSheet.CheckBoxes
If CB.Name <> ActiveSheet.CheckBoxes("Check Box 1").Name Then
CB.Value = ActiveSheet.CheckBoxes("Check Box 1").Value
End If
Next CB
End Sub
"
How you I go about only selecting Every checkbox from cell A9 - E9 ? Thanks any help would be appreciated.
I could really do with some help. I'm creating a timesheet for work where a user clicks on a check box which only selects the checkboxs for weekdays in a month. At the moment it auto selects everyday. This is the code I'm using to select all the checkboxs at once:
"Sub CheckBox1_Click()
Dim CB As CheckBox
For Each CB In ActiveSheet.CheckBoxes
If CB.Name <> ActiveSheet.CheckBoxes("Check Box 1").Name Then
CB.Value = ActiveSheet.CheckBoxes("Check Box 1").Value
End If
Next CB
End Sub
"
How you I go about only selecting Every checkbox from cell A9 - E9 ? Thanks any help would be appreciated.
