Calling user form on another workbook

[b0unce]

Hi guys,

I have searched the forum as well as google, but could not find explanation to my problem.
Currently my macro copies some information and pastes it to another workbook which has a userform. After the data is copied I want the user to be prompted with the user form. How can I do that?

UserForm.Show does not work, because I call it in different workbook that the form is. Any ideas?

Thanks!

 

[RoryA]

You need a macro in the other workbook that shows the userform, then call that macro.

 

[b0unce]

Could you please write a code to run a macro from another workbook?
On the one, which has that form I want to show, I have created a Public Sub.

 

[RoryA]

It's just:

Application.Run "'other workbook name.xls'!macro_name"

 

[b0unce]

Thanks!