by Mike Douglas (5 Submissions)
Category: Miscellaneous
Difficulty: Beginner
Date Added: Wed 3rd February 2021
Rating: (7 Votes)
A simple method to check if a form is loaded without referencing a property (such as .visible) that would in turn load the form.
Public Function IsFormLoaded(ByVal FormName As String) As Boolean
Dim frm As Form
For Each frm In Forms
If LCase(frm.name) = LCase(FormName) Then IsFormLoaded = True
Next frm
End Function