Hi Jonathan,

Try something like:

Private Sub CheckBox1_Click()
Rows("10:20").Hidden = Me.CheckBox1.Value
End Sub

---
Regards,
Norman



"Jonathan" wrote in message
...
I want to be able to hide and unhide rows depending if the value of a
checkbox is tru or false but I am getting no results.

Can anyone point me in the wright direction for the code? I am using the
VBA checkbox not the Forms checkbox.

Tia