If I have two excel files open and am running VBA application from one of them, when I try to do “User1.show”, it fails. I get a “Run Time error 9. Subscript out of range.”
However if I close the application I am not using at the moment the “User1.Show “ works as expected.

If I try to qualify the UserFrom1.Show with Workbook("Book1").UserFrom1.Show I get a compile error as "Sub or Function Not defined"

Any help would be appreciated,

Gary

Is there something within the initialization within the code of the form itself that might be throwing this error?

Brian,

Thanks for writing. I have fixed the problem by simply renaming UserForm1 to something else and changing references to it. The problem resulted from two VBA applications having the same form name.

gary

In this case, each VBA application has a project name. If you run into this again you can "fully qualify" the form names: Prj1.UserFrom1.Show, (etc.)

Glad you solved it.