VALIDATION FUNCTION HELP

  • Thread starter Thread starter KLZA
  • Start date Start date
K

KLZA

How can I use validation to stop users from entering the following
characters?: / \ : * ? " < > |
 
Restrict where?

This is code for a text box on a user form and allows specified ascii:

Private Sub TEXTBOXNAME_TextBox_KeyPress(ByVal KeyAscii As
MSForms.ReturnInteger)

Select Case KeyAscii
Case 48 To 57 ' 0 thru 9
Case 65 To 90 ' A thru Z uppercase. 97 to 122 is lowercase
Case Else
KeyAscii = 0
End Select

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VALIDATION FUNCTION HELP 2... 1
Passport date checker 1
get Data Validation to stop, list supplied, duplicate data entries 1
best way to validate data in forms; 2010 1
validated, stop all calculations on bad data 1
Excel 4 characters alphanumeric data validation check on one excel column. 1
Entering a long formumla in Validation criteria 4
Still can't validate entry 7

Back
Top