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
Cancel = True
Cancel = False
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,