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

Thanks

Greg

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" wrote in message
...
I am wonder is it possible to load a userform from another workbook. I am
having trouble working this out.

Thanks

Greg