R
Rmagic
Hello
I have a checkbox that i only want to become unlocked when a number is
put in this is my code
Private Sub CheckBox1_Click()
If ("N22") = "1" Or "2" Or "3" Then
CheckBox1.Value = False
CheckBox1.Enabled = False
Else
CheckBox1.Value = False
CheckBox1.Enabled = True
End If
End Sub
But it only works once and when you put other numbers in it still
remains locked??????
I have a checkbox that i only want to become unlocked when a number is
put in this is my code
Private Sub CheckBox1_Click()
If ("N22") = "1" Or "2" Or "3" Then
CheckBox1.Value = False
CheckBox1.Enabled = False
Else
CheckBox1.Value = False
CheckBox1.Enabled = True
End If
End Sub
But it only works once and when you put other numbers in it still
remains locked??????