Change State of Checkboxes

[Big Lar]

When Checkbox1 is checked…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

[FONT=Verdana]Private Sub CheckBox1_Click()<o:p></o:p>[/FONT]
[FONT=Verdana]<o:p></o:p>[/FONT]
[FONT=Verdana]TextBox1.Visible = True<o:p></o:p>[/FONT]
[FONT=Verdana]ListBox1.Visible = True<o:p></o:p>[/FONT]
[FONT=Verdana]<o:p></o:p>[/FONT]
[FONT=Verdana]End Sub<o:p></o:p>[/FONT]

<o></o>
<o></o>
How does one make TextBox and Listbox invisible when Checkbox is unchecked?<o></o>

 

[mikerickson]

Private Sub CheckBox1_Click()
    With CheckBox1
        TextBox1.Visible = .Value
        ListBox1.Visible = .Value
    End With
End Sub

 

[Smitty]

You can check its state then toggle visiblility based what happens:

If CheckBox1.Value = True then...

Or just do it directly like this:

Me.ListBox1.Visible = Not Me.ListBox1.Visible

HTH,

 

[Big Lar]

Thanks guys!

Mike's code does exactly what I need...again!