Class Module?
I have a userform that takes the user input, passes it to a worksheet where
the calculations are performed, then presents the results back to the
userform. To do this, I have two Sub Routines placed in a Module. They are
"UpdateCalculationsSheet" & "UpdateUserform".
For each control on the userform, I have placed an "AfterUpdate" Event. In
each "AfterUpdate" routine, I write:
Call UpdateCalculationsSheet
Call UpdateUserform
Instead of doing this for every single control on the userform, is there a
way I can write a SINGLE event for all controls on a userform? I'm not
familiar with class modules. I thought that might be the solution.
Ideally, I just want a Routine that is, Sub Userform_AfterUpdate(), but I
know this doesn't exist.
Thanks!
Steve
|