Using If statement to ascertain if a userform is hidden

[chrisjames25]

Hi I have 2 userforms that call up a third userform via a command button in each form if certain criteria within each is met.

THe third userform can also be called up using a command button on the main worksheet.

WHen I call the third userform up via the 2 userforms I user userform1.hide or userform2.hide to hide the initial userform.

When I have completed the task in the third userform and click clear I need the following to happen:

1) if I called userform 3 from the worksheet I unload the sheet and return to worksheet,
2) if I called userform 3 from userform 1, I unhide userform 1 and unload userform 3
3) if I called userform 3 from userform 2, I unhide userform 1 and unload userform 3

Is there an if statement whereby I can state If userform 1 has been initialised but hidden then do.... etc etc.

Any help is meuch appreciated.

[TMS]

You should be able to check the .visible property of the form for True or False. As for whether it's initialised, you might need to set your own flag when you execute the initialisation code.

Regards, TMS

[chrisjames25]

thanks for reply. How would I go about setting my own flags?

[TMS]

Define a public boolean variable outside the code, that is, at the top of standard module before the subroutines or in its own module.

For example:

Please Login or Register  to view this content.

By default, it will be set to False. In the Initialisation code for the form, put

Please Login or Register  to view this content.

.

And then, elsewhere, you can say

Please Login or Register  to view this content.

Regards, TMS

[Andy Pope]

Code to use userform3 from worksheet

Please Login or Register  to view this content.

from button on userform1 or userform2

Please Login or Register  to view this content.

[chrisjames25]

Genius - cheers for your help. THat code worked perfectly. If you have the time could you please look at my understanding of your code and fill in the blanks. Cheers again:

Please Login or Register  to view this content.

[Andy Pope]

Please Login or Register  to view this content.

[chrisjames25]

Many thanks for your replies. Will mark as solved.

[chrisjames25]

Hi Andy. Sorry one last thing that I don't think warrants a new thread so thought would ask here. ON userform 3 I have a textbox that is populated on inialisation. THis will be populated via a link to specified cell if accessed through the worksheet click button or via a value of a listbox in userofrm 1 or 2.

How can I amend your above code to make this happen or is it best done at a different step in the code.

[chrisjames25]

Scratch that I figured it out by tweaking the initialisation code to

Please Login or Register  to view this content.

CHeers again