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

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
>
>
>
>