View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chemicals chemicals is offline
external usenet poster
 
Posts: 25
Default Validation subroutine for textboxes

I hav a Userform with 24 textboxes on it. I would like to call a generic
validation routine on each change event. My problem is how do I generically
reference the control's value in the Change event routine ?

Here's what I am trying to do:

Private Sub txtOverallForward_Change()
CheckRange (Me.txtOverallForward.Value)
End Sub

but is there a way to do something like:
Private Sub txtOverallForward_Change()
CheckRange (Me.ActiveControl.Value) <-------
End Sub