IsFormLoaded causes the Open File Dialog box to appear!!!

[superlative]

Please Login or Register  to view this content.

The code above is famous - google "how to see if a userform is open" will give numerous answers pointing to the function above.

The problem is when I run this code:

Please Login or Register  to view this content.

and "ImportFilterForm" userform is not open - the File Open Dialog box opens!!! What is wrong and how do I stop the File Open Dialog Box from appearing? Thanks!!

[Kyle123]

Can’t you just check if the form is nothing, this seems like a hacky workaround for not properly instancing the form in the first place

[superlative]

I am willing to try anything. What's the code for checking if the form is nothing?

Is it:

Please Login or Register  to view this content.

I'll try anything. Just thought the OP code was the easiest way. Thanks.

[superlative]

I just tried

Please Login or Register  to view this content.

and it still opens up an Open File dialog box.

[Norie]

Do you have any code in the Initialize or Activate event of ImportFilterForm?

[superlative]

Yes - the first thing it does is open a File Open dialog box in the Userform_Initialize event. Thanks for helping me identify the problem!!! The thing is: why would the Initialize event trigger? Thanks!

[Norie]

For some reason the IsLoaded function, or other code associated with it, is causing the form you are trying to check on to be loaded.

How/where are you using IsLoaded?

[superlative]

I just found out the code in the OP does not in fact work. I tried testing it on Workbook Open event to see if ImportFilterForm is open or not, and it always thinks it's open. I found this alternative code that works properly:

Please Login or Register  to view this content.

This is surprising because the code in the OP is repeated in multiple places on the internet and many people said it worked for them, but it flat out does not work.

[superlative]

Norie: I did not use it previously. I came across the code in the OP at some time and added it to my list of functions.

Then I came across a situation to use it (a few days ago), but found it kept opening the File open dialog box.

[Norie]

Are you sure this IsLoaded function you wound is intended for Excel userforms?

I can recall writjing my own version of an IsLoaded function but it was for Access forms/reports and worked slightly differently.

Note, this was for Access 97 - the latest versions of Access now have an IsLoaded property that can be used for most objects, e.g. forms, reports etc in Access.

[superlative]

The second code in post #8 doesn't work either. I read someone else's suggestion that the only way to detect if a userform is open or not, is to set a variable. I think I might do that unless someone can come up with a better solution

[Norie]

Why do you want to check is a form is loaded?

[superlative]

In order to do this, I want to create a single Integer variable that will determine if any Userform is open.

If = 1, then ABC open
if = 10 then CDE open
If = 100 then FGH open
so if = 111 then ABC, CDE and FGH is open (etc).

Is there a mathematical "or" operator for this code to work?

eg.

Please Login or Register  to view this content.

Is there something like that? Thanks.

[superlative]

Norie: I have generic Message Box forms with progress bars, and I want to dynamically change the message depending on which userform is open, or even if this message form (Called MsgForm) is open.

For example If IsLoaded(Msgform) then MsgForm.MessageLabel.Caption = "Now running the XYZ step.."

[Norie]

Not sure I follow.

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.