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

Class Module?
 

Unfortunately you don't get an AfterUpdate event with application events in
this manner, not even an Exit event

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"steve" wrote in message
...
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

Class Module?
 

See if this info from J-Walk helps any.
http://j-walk.com/ss/excel/tips/tip44.htm

Charles
steve wrote:
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

Class Module?
 

so my only option is to place an event for each control?

"Bob Phillips" wrote:

Unfortunately you don't get an AfterUpdate event with application events in
this manner, not even an Exit event

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"steve" wrote in message
...
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

Class Module?
 

Yes, that is the bottom line to the best of my knowledge.

--
Regards,
Tom Ogilvy


"steve" wrote:

so my only option is to place an event for each control?

"Bob Phillips" wrote:

Unfortunately you don't get an AfterUpdate event with application events in
this manner, not even an Exit event

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"steve" wrote in message
...
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

Class Module?
 

That won't work for afterupdate (or exit or beforeupdate or enter)

Only events native to the control - not those provided by the container.

--
Regards,
Tom Ogilvy


"Die_Another_Day" wrote:

See if this info from J-Walk helps any.
http://j-walk.com/ss/excel/tips/tip44.htm

Charles
steve wrote:
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