VBA characters only in Text box

[ziad alsayed]

dear all

please need VBA code that allow only characters in TextBox.

i am using excel 2007.

thanks in advance

 

[Warship]

This will allow only A-Z or a-z

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

    If (KeyAscii < 65 Or KeyAscii > 90) And (KeyAscii < 97 Or KeyAscii > 122) Then KeyAscii = 0
    
End Sub

 

[ziad alsayed]

thanks warship , it is working