Solved: Make textbox visable or not visable on Userform

[Barryj]

Is it possible to make a textbox visable when a checkbox is checked and not visable when not checked?

I tried this code but it is not working.

Private Sub Checkbox1_Click
If CheckBox1 = True Then
TextBox1.visable = True
Sheets("Workings2").Range("D1") ="NCR"
TextBox2.Value = Sheets("Workings2").Range("D3")
Else
If CheckBox1 = False Then
TextBox1.visable = False
Sheets("Workings2").Range("D1") = ""
TextBox1.Value = Sheets("Workings2").Range("D3")
End If
End If
End Sub

[RonMcK]

First, yes, you should be able to. Second, try it again spelling visible with and 'i' (eye) instead of an 'a'.

Cheers!

[Barryj]

Thanks Ron that has fixed it, it's 0220 here and the brains in low gear, thanks again.

[RonMcK]

G'day (or should it be G' Night) Barryj,

When in doubt review the Properties panel in VBE.

Cheers,