I am trying to find a way that I can hide a userform open a seconday one, and
once I close the other one it will check through 3 userforms to find which
one is hidden and show it.

What i have are 3 main userforms: ufMain1, ufMain2, ufMain3
and a secondary userform with a different function: ufCont

What I have is on each of the main user forms they have a button that hides
the form that is loaded, opens ufCont, allows the user to finish their input
and post it to the sheet, however when i hit the close button cmbClose I want
it to check if the main forms are just hidden (not unloaded) and go back to
the form they where working on.

Is this at all do-able?

Just put this in each of your main UserForm's Button's click events...

Me.Hide
ufCont.Show
Me.Show

The current UserForm will be hidden and the ufCont one will be shown... when
you close the ufCont UserForm, the UserForm whose button you clicked should
automatically be re-shown.

--
Rick (MVP - Excel)


"Alteran" wrote in message
...
I am trying to find a way that I can hide a userform open a seconday one,
and
once I close the other one it will check through 3 userforms to find which
one is hidden and show it.

What i have are 3 main userforms: ufMain1, ufMain2, ufMain3
and a secondary userform with a different function: ufCont

What I have is on each of the main user forms they have a button that
hides
the form that is loaded, opens ufCont, allows the user to finish their
input
and post it to the sheet, however when i hit the close button cmbClose I
want
it to check if the main forms are just hidden (not unloaded) and go back
to
the form they where working on.

Is this at all do-able?