Userforms

[Greg]

I am wonder is it possible to load a userform from another workbook. I am
having trouble working this out.

Thanks

Greg

[Bob Phillips]

Greg,

I think you will have to create a procedure in the workbook that contains
the userform that launches that userform, just a simple Userform1.Show.

Then in the other workbook, use Application.Run to run that procedure.

Application.Run "'Other Workbook.xls'!RunForm"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Greg" <[email protected]> wrote in message
news:[email protected]...
> I am wonder is it possible to load a userform from another workbook. I am
> having trouble working this out.
>
> Thanks
>
> Greg
>
>