Restrict Special character issue

[Noz2k]

So I want to disallow both numeric and special characters (!"£$% etc) from a textbox. I have used this code which disallows all numbers and the majority of special characters, however for some reason certain characters such as £ and [ still come up when pressed. Any idea why or how to prevent this?

Private Sub Textbox_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If Not KeyAscii >= 65 And KeyAscii <= 90 Then
If Not KeyAscii >= 97 And KeyAscii <= 122 Then
KeyAscii = 0
End If
End If

End Sub

 

[GTO]

Try:

Private Sub Textbox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
    
    If Not (KeyAscii >= 65 And KeyAscii <= 90) _
    And Not (KeyAscii >= 97 And KeyAscii <= 122) Then
            KeyAscii = 0
    End If
End Sub

 

[ogo]

try this,
Private Sub Textbox_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If Not KeyAscii >= 65 And KeyAscii <= 90 Then
If Not KeyAscii >= 97 And KeyAscii <= 122 Then
If KeyAscii >= 33 And KeyAscii <= 47 Then
If KeyAscii >= 58 And KeyAscii <= 64 Then
If KeyAscii >= 91 And KeyAscii <= 96 Then
If KeyAscii >= 123 then
KeyAscii = 0
End If
End If
End If
End If
End If
End If
End Sub

 

[Noz2k]

Thanks GTO that works perfectly. Will utilise the And Not in other parts of my code also. Very useful to know, as well as _ continues the line. Thanks.



ogo, thanks for your help also, however your technique does not work.

 

[GTO]

Happy to help