Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
Show Results in TextBoxes, ONLY if All TextBoxes have Data in them | Excel Programming | |||
How To Quit Subroutine from a called subroutine | Excel Programming | |||
format validation in UserForm textboxes | Excel Programming | |||
Every second subroutine | Excel Programming |