UserForm X

[grumpyoldman]

I have a UserForm that calls another UserForm, when I press The X on the second UserForm it closes and goes Back to First UserForm then on the Second Visit The X no longer cancels the Second UserForm.
Could anyone Help Me Please.
the form closes using.....

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Unload Me
UserForm3.Hide
Teams.Show
End Sub

But this only works Once.

 

[dmt32]

Hi
Try following & see if resolves your issue

1 - Delete this code in second userform

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Unload Me
UserForm3.Hide
Teams.Show
End Sub

2 - In your Teams Userform, Update the code that calls the second userform

Example

Private Sub CommandButton1_Click()
    Me.Hide
    UserForm3.Show
    Me.Show
End Sub

As you are using the X close button to dismiss Userform3, this is the same as using the Unload method.

Hope Helpful

Dave

 

[grumpyoldman]

Hi
Try following & see if resolves your issue

1 - Delete this code in second userform

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Unload Me
UserForm3.Hide
Teams.Show
End Sub

2 - In your Teams Userform, Update the code that calls the second userform

Example

Private Sub CommandButton1_Click()
    Me.Hide
    UserForm3.Show
    Me.Show
End Sub

As you are using the X close button to dismiss Userform3, this is the same as using the Unload method.

Hope Helpful

Dave

Excellent Worked Perfectly Thank you so Much.!!!!!!

 

[dmt32]

Excellent Worked Perfectly Thank you so Much.!!!!!!

welcome glad resolved & appreciate your feedback

Dave