checkbox: VBA excel control multiple checkboxes with 1 macro

lundi 9 octobre 2017

I have a quite simple macro to hide the row the checkbox is in when clicked. It works but the problem is there are A LOT of rows.

    Private Sub CheckBox3_Click()
    [3:3].EntireRow.Hidden = CheckBox3.Value
    Range("AB3").Value = True

End Sub

I of course can make a separate macro for every single checkbox i have (all 250 of them), but i hope i can avoid a macropage that is 6 pages long.

My question is: is there a way to combine it into 1? the only thing that is different for all of them is the number (in the example its 3).

checkbox