Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
class module? | Excel Programming | |||
Class Module | Excel Programming | |||
Class module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |