Checkbox to show/hide rows on two sheets

[lager28]

I have a workbook with three worksheets. On the first worksheet the user is asked to identify the discipline that relates to their project using an Active X Checkbox.

So, they might select "Electrical" and "Mechanical" but not "Architectural".

Based on their selection, corresponding rows will appear on the active worksheet (let's say sheet1) as well as sheet 2.

I have managed to figure out how to do this on the active worksheet using the following code for each checkbox (I have 8 checkboxes):

Private Sub CheckBox1_Click()
    [22:25].EntireRow.Hidden = Not CheckBox1
End Sub

What I cannot figure out is how to get the same result for an array of rows on sheet 2 that have the word "Electrical" or "Mechanical" in column A".

Any help is appreciated.

 

[Fluff]

Maybe

Private Sub CheckBox1_Click()
     [22:25].EntireRow.Hidden = Not CheckBox1
     Sheets("Sheet2").row("22:25").EntireRow.Hidden = Not CheckBox1
End Sub