tru-numbers
asked on
Auto load beforeUpdate event
I have about 300 text fields to load a function into the beforeUpdate event. Is there a way to auto load the function in all the desired text fields?
ASKER
Thanks andrewssd3,
Fields are on a userform. I want to insert
Call getControlInfo(ActiveContr ol)
to the fieldName_beforeUpdate event
I check the user entry with this code and its' as follows:
If TypeOf ctrl Is MSForms.Frame Then
Set getControl = getControlInfo(ctrl.Active Control)
ElseIf TypeOf ctrl Is MSForms.MultiPage Then
Set getControl = getControlInfo(ctrl.Object .SelectedI tem.Active Control)
Else
Set getControl = ctrl
frmProgramAdmin.fldName = ctrl.Name
frmProgramAdmin.fldValue = ctrl
If validDate(frmProgramAdmin. fldValue) = False Then
frmProgramAdmin(ctrl.Name) = ""
End If
If validNumber(frmProgramAdmi n.fldValue ) = False Then
frmProgramAdmin(ctrl.Name) = ""
End If
End If
Fields are on a userform. I want to insert
Call getControlInfo(ActiveContr
to the fieldName_beforeUpdate event
I check the user entry with this code and its' as follows:
If TypeOf ctrl Is MSForms.Frame Then
Set getControl = getControlInfo(ctrl.Active
ElseIf TypeOf ctrl Is MSForms.MultiPage Then
Set getControl = getControlInfo(ctrl.Object
Else
Set getControl = ctrl
frmProgramAdmin.fldName = ctrl.Name
frmProgramAdmin.fldValue = ctrl
If validDate(frmProgramAdmin.
frmProgramAdmin(ctrl.Name)
End If
If validNumber(frmProgramAdmi
frmProgramAdmin(ctrl.Name)
End If
End If
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for tru-numbers's comment #37831970
for the following reason:
I did this in error
Accepted answer: 0 points for tru-numbers's comment #37831970
for the following reason:
I did this in error
Even so, I did give some relevant help with supporting documentation, so it would be good to allocate some points at least rather than just deleting the question altogether.
ASKER
Thanks
Stuart