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!
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!