Hide & Unhide with a Checkbox

[Guest]

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

 

[Norman Jones]

Hi Jonathan,

Try something like:

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

 

[Guest]

Thnx Norman I'll givie it whirl

Hi Jonathan,

Try something like:

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

 

[Guest]

Thanks Norman,

What I mean (have tested and it's fab) but the rows will start hidden on the
sheet - when the user check's the box and creates the Value "True" I want the
rows to be visible when the box is unchecked and the value "False" I want the
rows to be hidden.

Can you help?

 

[Norman Jones]

Hi Jonathan,

What I mean (have tested and it's fab) but the rows will start hidden on
the
sheet - when the user check's the box and creates the Value "True" I want
the
rows to be visible when the box is unchecked and the value "False" I want
the
rows to be hidden.

Try:

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

 

[Guest]

Thanks Norman your a star!

Hi Jonathan,



Try:

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