showing a Userform from another workbook

[Todd Huttenstine]

How do I call a userform (userform1) from another workbook called test.xls?
Normally you would day userform1.show but when its on another workbook it
does not work. I have done it before I just forgot the code.

Thanx

Todd Huttenstine

 

[Ivan F Moala]

Hi Todd

Your other Workbook would need to be Open & have a Loader routine
ie A routine that Opens/shows the Userform

Application.Run "Name_Of_Other_WorkBook!Loader_Routine"