Passing Procuedure to Userform

In article <[email protected]>, nigel-
[email protected] says...
> I have a userform that is called from a worksheet event. On initialising I
> wish to run a procedure held in a standard module, the procedure changes
> depending on the value of the worksheet event.
>
> How do I pass the name of the procedure to the userform initialise event ?
>
>
Check out the Application object's Run method. It accepts the name of
the procedure to call as a string argument.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Thanks everyone that has given me some ideas.

--
Cheers
Nigel



"Tushar Mehta" <[email protected]> wrote in message
news:[email protected]...
> In article <[email protected]>, nigel-
> [email protected] says...
> > I have a userform that is called from a worksheet event. On
initialising I
> > wish to run a procedure held in a standard module, the procedure changes
> > depending on the value of the worksheet event.
> >
> > How do I pass the name of the procedure to the userform initialise event
?
> >
> >
> Check out the Application object's Run method. It accepts the name of
> the procedure to call as a string argument.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions