form validation

[Jymoz]

is there a way to add validation rules to a form, i need it so that the user can only enter certain types of file but i dont know how to do it

[raypayette]

Private Sub CommandButton1_Click()
If Not IsNumeric(TextBox1.Value) Then MsgBox "Non numeric input", vbInformation
End Sub

[davesexcel]

is there a way to add validation rules to a form, i need it so that the user can only enter certain types of file but i dont know how to do it

at the top menu goto data,validation

http://www.contextures.com/xlDataVal01.html

http://www.contextures.com/xlDataVal08.html

[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

[davesexcel]

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

Please Login or Register  to view this content.

[Jymoz]

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

Please Login or Register  to view this content.

i can be really bad at explaining things sometimes sorry

thanks for the code though