Barryj
06-26-2008, 09:16 AM
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
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