showing a Userform from another workbook

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

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
 
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"
 
Back
Top