+ Reply to Thread
Results 1 to 2 of 2

Running Userform Procedure

  1. #1
    Nigel
    Guest

    Running Userform Procedure

    Hi All
    I have a procedure linked to a UserForm control (ControlButton). The
    UserForm is automatically opened from the Workbook open event. When the
    UserForm control is clicked the procedure runs updating datasets and
    displaying various information in other parts of the UserForm. This works
    OK.

    What I would like to do is intitiate the procedure automatically when the
    UserForm is first opened or soon afterwards, Ineed the UserFrom to be
    visible in order for the information update to be seen by the user. So I
    tried placing a call to the UserForm control event in the UserForm intialize
    event eg Call ControlButton1_Click but this does not work? I have also
    tried putting a time delay using OnTime to intiate it after a few seconds
    but again no luck. There must be an obvious answer but I cannot figure it
    out !! Anybody got a solution please ??

    --
    Cheers
    Nigel





  2. #2
    Mangesh Yadav
    Guest

    Re: Running Userform Procedure

    Hi Nigel,

    It ought to work that way. You are probably missing something. Post your
    code.

    Mangesh



    "Nigel" <[email protected]> wrote in message
    news:#[email protected]...
    > Hi All
    > I have a procedure linked to a UserForm control (ControlButton). The
    > UserForm is automatically opened from the Workbook open event. When the
    > UserForm control is clicked the procedure runs updating datasets and
    > displaying various information in other parts of the UserForm. This works
    > OK.
    >
    > What I would like to do is intitiate the procedure automatically when the
    > UserForm is first opened or soon afterwards, Ineed the UserFrom to be
    > visible in order for the information update to be seen by the user. So I
    > tried placing a call to the UserForm control event in the UserForm

    intialize
    > event eg Call ControlButton1_Click but this does not work? I have also
    > tried putting a time delay using OnTime to intiate it after a few seconds
    > but again no luck. There must be an obvious answer but I cannot figure

    it
    > out !! Anybody got a solution please ??
    >
    > --
    > Cheers
    > Nigel
    >
    >
    >
    >




+ 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