I think you would probably have to use the FindWindow API to do this. The reason is, any time you reference a form, it gets instantiated. So, the test:
VB Code:
If UserForm1 Is Nothing Then
will always evaluate to false--the form will be "not nothing" as soon as the test is made. The way around these issues would be to never let a form load implicitly. Do all of your form loading by setting a variable for the form and explicitly creating and destroying it's reference:
VB Code:
Dim oForm As UserForm1
Set oForm = New UserForm1
oForm.Show
Set oForm = Nothing
Reply With Quote
