WD2000: Unable to Show User Form in Other Projects (211267)

WORKAROUND

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. To work around this design behavior, you can call a macro in a project containing your User Form. That macro displays the User Form in that project. The following Visual Basic for Applications example demonstrates how to do this and assumes the following:

• You have two projects and they are called Project1 and Project2.
  
  -and-
• Project1 contains a module called Module1. This project module contains the commands to call a macro in Project2, Module1.
  
  -and-
• Project2 contains a module called Module1. This project also contains your User Form. This project module (Module1) contains the commands to show the User Form.

Use the following steps to display the User Form in Project2 from Project1:

1. Make sure that each project has a unique name (as shown in the Properties window for each project).
   
   To rename a project:
   1. In the Visual Basic Editor, on the View menu click to check Project Explorer.
   2. In the Project Explorer window, click to select the project name.
      
      For example, your project may appear as follows:

      Project(MyDocument)

   3. On the Tools menu, click <YourProjectName> Properties where <YourProjectName> is the current name of your project.
   4. In the Project Properties dialog box, type to change the name of your project in the Project Name text box.
   5. Click OK to accept your changes.
2. In the Project Explorer window, click to select Project1(<Your Document or Template Name>).
3. In Module1 of Project1, enter the following macro:

   Sub RunProject2Macro()
      Application.Run "Project2.Module1.ShowForm"
      'call the subroutine in Project2
   End Sub
   						

4. In Module1 of Project2 (the project containing the User Form), enter the following macro:

   Sub ShowForm()
      UserForm1.Show
   End Sub
   						

5. Run the RunProject2Macro macro in Module1 of Project1.

The User Form in Project2 now appears without generating the error message as described earlier in this article.