How to know if userform running

[Rasm]

I am using a XLAM add-in code - I have multiple forms - But I want to prevent the user from loading another userform unless I terminate the one already running.

So how can I determine which form may or may not be running?

 

[pedie]

I think to terminate or before loading other userform you can enter a line

[/FONT]
[FONT=Courier New]unload me[/FONT]
[FONT=Courier New]or [/FONT]
[FONT=Courier New]unload userform1[/FONT]
[FONT=Courier New]'etc[/FONT]
[FONT=Courier New]userform2.show 'vbmodeless if you want it to be modeless etc[/FONT]
[FONT=Courier New]

Not sure if this helps

 

[Rasm]

I tried the unload command - then immediately followed by my load command - but I get caught in a bad loop.

 

[pedie]

Is it possible to show me your whole [userform] code you have?

 

[Leith Ross]

Hello Rasm,

Perhaps this macro will help. It will display a dialog box listing the currently running or loaded UserForms.

Sub ShowUserFormList()

  Dim I As Integer
  Dim Msg As String
  
    For I = 0 To .UserForms.Count - 1
        Msg = Msg & UserForms(I).Name & vbCrLf
    Next I
    
    MsgBox "The follow UserForms are loaded or running:" & vbCrLf & Msg
    
End Sub

Sincerely,
Leith Ross

 

[Rasm]

Leith
Looks exactly like what I was looking for - I will try that - but sure looks like a winner
Thanks

 

[Rasm]

Leith - that worked - thanks