Hi All,

I have 20 Check boxes Named C100 thru C120

for all the checkboxes i have:

Private Sub C100_change()
Macro1
End Sub

thru .....


Private Sub C120_change()
Macro1
End Sub

instead of repeating this afor all 20 checkboxes is there any other way
to do this?

Thanks