textbox max of 2 and min of 1

[Jefferson2512]

is it possible to input 1 and 2 only in textbox ?

 

[JoeMo]

Maybe this for an active-x textbox named "Textbox1".

Private Sub TextBox1_Change()
If Not TextBox1.Text = "1" And Not TextBox1.Text = "2" And Not TextBox1.Text = "" Then
    MsgBox "Only text permitted is a 1 or a 2 - try again"
    TextBox1.Text = ""
    Exit Sub
End If
End Sub

 

[Jefferson2512]

okay man I'll try this one .. all the best