Consulting

Results 1 to 4 of 4

Thread: Solved: check if anything in userform changed

  1. #1

    Solved: check if anything in userform changed

    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

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    There are some possible shortcuts, but essentially you have to check everything. There is very little inbuilt functionality.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    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.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  4. #4
    ok
    thx for help.
    i will try it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •