Using If statement to ascertain if a userform is hidden

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.

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

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:

Private Sub CommandButton1_Click()

    Dim frmU3 As UserForm3 ' define userform3 as frmu3
    
    Set frmU3 = New UserForm3 ' not sure on this step in code
    Me.Hide ' hide current userform
    frmU3.Show 'show userform 3
    Unload frmU3 ' unload userform 3 - is this only triggered once the unload me code is ran within the userform 3 sequence????
    Set frmU3 = Nothing ' again not sure on this 
    Me.Show ' show original form again
    
End Sub

Many thanks for your replies. Will mark as solved.

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

 

  Dim Category As Variant
   If PottingForm.CategoryLst <> "" Then
   Category = PottingForm.CategoryLst
     Else
     
     Category = ActiveSheet.Cells(4, 3)
     End If

CHeers again

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.