Unhide rows using checkbox in excel 2010

Hi guys

I have searched through the forum a few times but can't find my solution.

I am trying to build a sheet where, upon opening the sheet, rows (say 5 to 10, then 11 to 15) are hidden.

The user will have two checkboxes to choose from.

When checkbox 1 is selected, rows 5 to 10 are unhidden. If checkbox 1 is clicked again, rows 5 to 10 disappear again.

Checkbox 2 unhides and hides rows 11 to 15.

The code for the opposite of this scenario (hides rows when selected) is as follows:

Sub CheckBox1_Click()
With Rows("5:10")
        .Select
       .EntireRow.Hidden = Not .EntireRow.Hidden
    End With

End Sub

I have tried recording the scenario on excel, but so far have had no success. I'm sure this is ridiculously easy for someone out there...

Thanks for reading, please reply if you have any good ideas!

This may help you:

Sub CheckBox1_Click()
    If CheckBox1.Value = True Then
        Rows("5:10").EntireRow.Hidden = True
    Else
        Rows("5:10").EntireRow.Hidden = False
    End If
End Sub

Hi Gerard

Thanks for your reply.

I have copied the code supplied into excel, however I am now getting the following error: 'Run-time error '424' - Object required'.

On debug, the error is displaying on line 2 "If CheckBox1.Value = True Then".

I'm sure this is close to the solution though!

Ok, I couldn't see what kind of control you where using.
Place a ActiveX check box in the sheet and dubbel click it than it opens the IDE.
Place the code in the created privite sub of the ActiveX control.

Gerard, thanks again. I omitted to mention I was using form controls!

I am now using ActiveX as you suggest, and the code is compiling.

However, this is working in a similar fashion to my old code: when the box is ticked, the rows disappear - I need the opposite to happen.

However, I simply inverted the 'True' and 'False' statements and everything works perfectly.

Thanks a million buddy!