PDA

View Full Version : Solved: check if anything in userform changed



danovkos
09-10-2010, 06:18 AM
Hi,
pls. is here any way to do following?
I have userform (UF) with many controls, buttons, combos and radios.
And i want to do some actions after each action/move/click/selec which i do in this userform.
I konw, that i can define each action separately like (Private Sub ComboDE_Change()) but i don want do define each my control.

Is here any way to define:
If i do something (No matter what) with this UF do this...

thx

Bob Phillips
09-10-2010, 07:12 AM
There are some possible shortcuts, but essentially you have to check everything. There is very little inbuilt functionality.

Jan Karel Pieterse
09-10-2010, 07:43 AM
You can create a class module which responds to the userform's control events and use that class to handle events for identical controls in one place. See example file.

danovkos
09-10-2010, 01:13 PM
ok
thx for help.
i will try it.