VBA Textbox Validation 1

[vestax22]

Hi, I created an Excel application that calls a userform. Inside this form I have many text boxes which I would like to validate and since there are no format or input mask properties in VBA textboxm I have to do it manually.

I want to use the keypress event to make sure that only numeric values are entered inside a specific textbox. Does anyone here know how to do this?

Any help would be greatly appreciated

Thx

 

[jcrater]

In the keypress event:

If KeyAscii < 48 Or KeyAscii> 57 Then
KeyAscii = 0
End If