Closing userform with X multiple times ??

**deucejmp** · 11-19-2012, 08:35 PM

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?

**6StringJazzer** · 11-19-2012, 09:46 PM

Can you post the code you have in UserForm_QueryClose? Even better, post the file.

Are the forms modal? I tried to reproduce this. When QueryClose tries to open the other form, I get an error because it is attempting to show another form while it is still displayed itself. Both forms are modal so this is not allowed.

**JosephP** · 11-20-2012, 03:39 AM

userform2 should not show userform1-userform1 should do that itself. so userform1 code is

Please Login or Register  to view this content.

and userform2 doesn't actually need any code in its queryclose event since it's being unloaded anyway

Closing userform with X multiple times ??

LinkBack

Thread Tools

Rate This Thread

Display

Closing userform with X multiple times ??

Re: Closing userform with X multiple times ??

Re: Closing userform with X multiple times ??

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions