Solved: Determine if Userform is Loaded

[abhiker]

Is there a VBA command that allows you to check to see if a UserForm is already diplayed or loaded? Thanks in advance for any help on this.

[Bob Phillips]

Loaded forms are all contained in userforms collection, so just check that.

[abhiker]

This is my solution. Thanks for the advice.

Dim frm As Object

For Each frm In UserForms

MsgBox frm.Name

Next frm

[mdmackillop]

To avoid repeated messages

Dim frm As Object
Dim msg As String
For Each frm In UserForms
msg = msg & frm.name & vbCr
Next frm
MsgBox msg