Hi,
I'm using a userform with several textboxes. I want to check them on userinput.
When the input is text it must return a msgbox, when it's a value it can go on to the next textbox.
I'm using the following code to do the checking.
Private Sub txt1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
If Not IsNumeric(txt1) Then
MsgBox "test"
Cancel = True
Else
Cancel = False
End If
But do I have to copy the code for each textbox ie txt1 to txt10 or can I use a loop? Any suggestions are welcom.
Thanx very much,
Fluppe :tumble: