form validation

Originally Posted by Jymoz

on those links where is it i need to look?

i can find info about general validation but not about a text box in a VB form

Sorry didn't understand your original question.

raypayette's will do what you asked, when you click the command button the message will show if the data was wrong,

or you can place the code in a textbox exit event something like

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox1.Value > 5 Then
MsgBox "Greater than 5"
End If
End Sub