Userform Show Modal

[Av8tordude]

I have two userform (Userform A - ShowModal=True & Userform B - ShowModal=False). When I minimize A, B appears. When I close B, A also closes. I want A to remain showing. How can i make B remain open when I close A. (Confused...my apologies)

 

[My Aswer Is This]

I'm not sure how you Minimize a UserForm

Please show us the code your using to close Your UserForm.

And show me the code your using to Minimize your UserForm.

And just curious why you need 2 UserForms Open at the same time.

I have used UserForms for years and never needed 2 open at the same time.

 

[Yongle]

Try ...

On worksheet - opens userform1 modeless

Private Sub CommandButton1_Click()
    UserForm1.Show vbModeless
End Sub

In userform1 - hides userform1 and opens userform2 modal

Private Sub CommandButton1_Click()
    UserForm1.Hide
    UserForm2.Show vbModal
End Sub

In userform2 - shows userform2 (with values all retained) when userform2 is closed (using X in top-right-corner)

Private Sub UserForm_Terminate()
    UserForm1.Show
End Sub

 

[Yongle]

ooooops! you probably already spotted the inconsistency in previous post - it won't work after the first hop between the forms

userform2 code should be

Private Sub UserForm_Terminate()
       UserForm1.Show vbModeless
End Sub

 

[Yongle]

I suspect my earlier suggestion may not deliver what you want

Excel is a bit "picky" when trying to keep more than 1 userform open at the same time. But there is a number of different ways to give the user what is required and allow values to be retained etc. But we need to understand what your overall needs are.

If above solution is not helpful ...

Post current code (as requested by @My Aswer Is This)

What is the purpose of both forms ?
Why do they need to be 2 separate forms ?
What (else) you need user to be allowed to do when userform1 is open and (separately) when userform2 is open ?
Why does userform1 need to be kept open when userform2 is shown ?