How check if form is loaded?

Hi,

is it possible to check if a specific form is loaded into memory?

Thanks,
Jos Vens

"Jos Vens" <[email protected]> wrote in message
news:%[email protected]...
> Hi,
>
> is it possible to check if a specific form is loaded into memory?
>
> Thanks,
> Jos Vens
>
>

It's possible to test whether a form is being shown. That's perhaps not what
you meant.

/Fredrik

Hi Fredrik,

yes it is, I just want to test if a form is shown or not but how?

Thanks
Jos

"Fredrik Wahlgren" <[email protected]> schreef in
bericht news:Ognf%[email protected]...
>
> "Jos Vens" <[email protected]> wrote in message
> news:%[email protected]...
>> Hi,
>>
>> is it possible to check if a specific form is loaded into memory?
>>
>> Thanks,
>> Jos Vens
>>
>>
>
> It's possible to test whether a form is being shown. That's perhaps not
> what
> you meant.
>
> /Fredrik
>
>

Hi Jos,

Private Function FormIsLoaded(UFName As String) As Boolean
Dim UF As Integer
For UF = 0 To VBA.UserForms.Count - 1
FormIsLoaded = UserForms(UF).Name = UFName
If FormIsLoaded Then Exit Function
Next UF
End Function

Sub Test()
'Load UserForm1
MsgBox FormIsLoaded("UserForm1"), 64
'If FormIsLoaded("UserForm1") Then Unload UserForm1
End Sub

Regards,
MP

"Jos Vens" <[email protected]> a écrit dans le message de
news:%[email protected]...
> Hi,
>
> is it possible to check if a specific form is loaded into memory?
>
> Thanks,
> Jos Vens
>
>

Thanks a lot Michel!

Your code does the job I wanted,

Jos


"Michel Pierron" <[email protected]> schreef in bericht
news:%[email protected]...
> Hi Jos,
>
> Private Function FormIsLoaded(UFName As String) As Boolean
> Dim UF As Integer
> For UF = 0 To VBA.UserForms.Count - 1
> FormIsLoaded = UserForms(UF).Name = UFName
> If FormIsLoaded Then Exit Function
> Next UF
> End Function
>
> Sub Test()
> 'Load UserForm1
> MsgBox FormIsLoaded("UserForm1"), 64
> 'If FormIsLoaded("UserForm1") Then Unload UserForm1
> End Sub
>
> Regards,
> MP
>
> "Jos Vens" <[email protected]> a écrit dans le message de
> news:%[email protected]...
>> Hi,
>>
>> is it possible to check if a specific form is loaded into memory?
>>
>> Thanks,
>> Jos Vens
>>
>>
>