Reuse text box validation code for multiple text boxes

[zinzah]

hi again...

I have a userform...with multiple frames...each containing multiple text boxes.
i am using this code to validate one text box in one part of my code

Sub tbxEndGameNum_Change()
Debug.Print "tbxEndGameNum_Change()"


If Len(tbxEndGameNum) = 4 Then
'Application.ScreenUpdating = False

  If IsNumeric(tbxEndGameNum.Value) = False Or tbxEndGameNum.Value = vbNullString Then
        If (tbxEndGameNum.Value < 1300 Or tbxEndGameNum.Value > 2500) Then
            Selection = MsgBox("Please enter a valid 4 digit game number", 1, "INVALID GAME NUMBER!")
            tbxEndGameNum.Value = ""
            tbxEndGameNum.SetFocus
            Exit Sub
        End If
    Else
        MsgBox "Your input data is not valid"
        tbxEndGameNum.Value = ""
        tbxEndGameNum.SetFocus
        Exit Sub

End If

Call Processing
End If
End Sub

Wondering what i have to do/where do i need to move this/how do i change it so that i can call the same validations for all the textboxes when data in entered?

 

[zinzah]

yours does work...with no issues.
I have a lot of confidential data in there. would take a while.....but i'll give it a shot....

ok...don't yell at me....

The textbox is losing focus to a FRAME that it is in....
trying to figure that out...

And i'll still look into striping out anything i need to before sharing...