Article ID: 213583 - View products that this article applies to.
This article was previously published under Q213583
This article has been archived. It is offered "as is" and will no longer be updated.
There is no way to directly show a UserForm that is contained in another Microsoft Visual Basic for Applications project.
If you want to show a UserForm that is contained in another project you must either:
Importing a UserForm from Another Project
NOTE: If you want any macro code that is associated with the UserForm to also be imported with the UserForm, make sure this code is contained on the UserForm's code module and not simply on a module sheet inserted into the project.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
Referencing Another ProjectIn this example, the two projects in question will be VBAProject1 and VBAProject2. VBAProject1 is the project that contains your macro code from which you want to display the UserForm in VBAProject2. With this workaround, both UserForms can have the same name because the .Show method always shows the UserForm in the current project.
NOTE: In order to create a reference from VBAProject1 to VBAProject2, the file containing VBAProject2 must be a saved workbook.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
For more information about showing a user form, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type Show Method in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about creating a reference to another project, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type References Command (Tools Menu) in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Contact us for more help