putting validation to TextBox in the userform

  • Thread starter Thread starter salihyil
  • Start date Start date
S

salihyil

hello guys

i use userform to autofilter the data from the list. when i put th
username it just filters the usernames details.

Question:
does anyone know how to put validation to textbox. eg just letters. i
end-user puts number, i want system to show an error message.

and also if the text that will be put in textbox does not exist i
(data,list)i want system to show error messege.

if you can help i will appriciate guys

thank
 
I think this is along the right lines...

Private Sub textbox1_KeyPress(ByVal KeyAscii As _

MSForms.ReturnInteger)

If Not IsNumeric(Chr(KeyAscii)) Then
msgbox "Please only use numbers"
KeyAscii = 0
End If

End Sub

Hope it is of some use
 
Back
Top