+ Reply to Thread
Results 1 to 3 of 3

Events in a Userform

  1. #1
    Trefor
    Guest

    Events in a Userform


    I have created a userform with tabs, combo boxes, text boxes, etc. I am
    guessing from my research here that by using an "event" I can check to see if
    the user has modified the form? From this event I would like to update
    information on the form. I am new to userforms and have never used events,
    could someone help me out here with some code? (I know I could add a call to
    every control on the form, but I would really like a catch all reduce the
    effort and chances that I might miss one).

    Any help would be very much appreciated.

    --
    Trefor

  2. #2
    Jim Rech
    Guest

    Re: Events in a Userform

    Double-click any of the userform controls to be taken to the userform module
    and the default event handler for said control. In the right dropdown at
    the top of the module will be all the events that that control handles.
    Pick the ones you want to write code for.

    --
    Jim
    "Trefor" <Trefor@home.com> wrote in message
    news:2C496401-29CA-424F-9539-2937613F7FA5@microsoft.com...
    |
    | I have created a userform with tabs, combo boxes, text boxes, etc. I am
    | guessing from my research here that by using an "event" I can check to see
    if
    | the user has modified the form? From this event I would like to update
    | information on the form. I am new to userforms and have never used events,
    | could someone help me out here with some code? (I know I could add a call
    to
    | every control on the form, but I would really like a catch all reduce the
    | effort and chances that I might miss one).
    |
    | Any help would be very much appreciated.
    |
    | --
    | Trefor



  3. #3
    Trefor
    Guest

    Re: Events in a Userform

    Jim, many thanks and sorry for the delay in getting back to you I have been
    working on another project.
    --
    Trefor


    "Jim Rech" wrote:

    > Double-click any of the userform controls to be taken to the userform module
    > and the default event handler for said control. In the right dropdown at
    > the top of the module will be all the events that that control handles.
    > Pick the ones you want to write code for.
    >
    > --
    > Jim
    > "Trefor" <Trefor@home.com> wrote in message
    > news:2C496401-29CA-424F-9539-2937613F7FA5@microsoft.com...
    > |
    > | I have created a userform with tabs, combo boxes, text boxes, etc. I am
    > | guessing from my research here that by using an "event" I can check to see
    > if
    > | the user has modified the form? From this event I would like to update
    > | information on the form. I am new to userforms and have never used events,
    > | could someone help me out here with some code? (I know I could add a call
    > to
    > | every control on the form, but I would really like a catch all reduce the
    > | effort and chances that I might miss one).
    > |
    > | Any help would be very much appreciated.
    > |
    > | --
    > | Trefor
    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1