How can this code be written for 10 - 20 check boxes in a row that do the same thing
So I do not have to write the code 10 - 20 times for each box

Private Sub CheckBox2_Click(
With CheckBox
If .Value = True The
Worksheets(2).Range("A9:C9").Value
ActiveSheet.Range("A9:C9").Valu
Els
Worksheets(2).Range("A9:C9").Value = "
End I
End Wit
End Su

Please help! Thank Yo