Consider the following, given two UserForms: UserForm1 and UserForm2.
Command button on UserForm1 hides UserForm1 and shows UserForm2
Private Sub UserForm_QueryClose on Userform2 hides UserForm2, then Unloads UserForm2 and then shows UserForm1
When Userform1 is showing and I click on the command button, UserForm2 shows. When I close out UserForm2, Userform1 shows as expected. If I click on the command button a second time, UserForm1 hides and UserForm2 shows. If I then try closing Userform2 again, nothing happens when click the [X]. Why is this?
Bookmarks