Show a userform in a different workbook

[davidkhbgh]

I need to show a userform which is in workbook A from a button on workbook B

Workbooks("Tally Sheet ver7.2.xls").UserForm.ProductionData.Show

I thought this would work but it doesn't.

Thanks, Dave

 

[hatman]

1) in WB A, in the VBA editor, rename the VBAProject to something meaningful, in the Project Explorer Pane.
2) with WB A still open, in WB B, in the VBA editor, select Tools->References, and check off the entry for the VBAProject name of WB A
3)in a module in WB A, you should be able to type the VBAProject name of WB B, then a period, and a list of all of the VB Objects in the VBAProject should be visible... select the name of the userform, then type .Show

Caveat: whenever WB B gets opened, so will WB A... you cannot close WB A until WB B is closed, and WB A will not close automatically when WB B is closed, unless you add code to do so.

It's the only way I know to get it done... unless you copy the form to the other workbook...

 

[davidkhbgh]

That worked. Thanks, Dave

 

[Jaafar Tribak]

Here is another way without having to set any workbook cross references:

Add the following routine in a standard module in WBK A where UserForm1 is the name of the form.

Sub ShowForm()

    UserForm1.Show

End Sub

Then to load the form from WBK B, run the following routine in :

Sub LoadForm()

    Run "A" & "!ShowForm"

End Sub

Regards.