Open userform from different workbook

[j844929]

Hi,

Can anyone tell me how to open a userform in one workbook by running code from a different workbook?

I have a workbook with a command button on a menu, which opens another workbook. After the other workbook is opened, I'd like another userform to appear, but one which is assigned to that particular workbook...

Tim

 

[onlyadrafter]

Hello,

THink I have found a workaround, but I'm sure it is not what you want.

In the spreadsheet that is being opened, can you not create a macro for the userform e.g.

Sub A_SHOW()
UserForm1.Show
End Sub

Then in the original sheet your code will be

Sub Macro4()
    Workbooks.Open FileName:="C:\clock.xls"
    Application.Run "clock.xls!A_SHOW"
End Sub

Obviously substituting with your file and macro name.