Detect if a Form is opened

[Vince]

Hi,

I would like to find out if a form is loaded or not. In VB I do something
like:

Private Function IsLoaded(frmname As String) As Boolean
Dim item As Form
IsLoaded = False
For Each item In Forms
If item.Name = frmname Then
IsLoaded = True
Exit Function
End If
Next item
End Function

but I don't have a Form type in VBA. How to I modify this under VBA so that
it works?

TIA,
Vince

 

[Jean-Guy Marcil]

Vince was telling us:
Vince nous racontait que :

Hi,

I would like to find out if a form is loaded or not. In VB I do

See Jezebel's answer to the exact same question posted by stephenc on June
6th in this newsgroup.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Vince]

Thanks!

Vince was telling us:
Vince nous racontait que :


See Jezebel's answer to the exact same question posted by stephenc on June
6th in this newsgroup.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org