Sherry,

This is how I have always done it.

You can't directly open the form from another project (file). What you could do is to create a Public Sub in the project containing the form, and then call that procedure from the other project using Application.Run.

So in the project with the form, say workbook myFormBook, add


Public Sub ShowForm()
UserForm1.Show
End Sub


Then, you can call this with Application.Run from the other project with


Application.Run "'myFormBook.xls'!ShowForm"