Userform Stalls when jumping from one form to another

Working with a project that utilized multiple userforms for data entry and form completion. I have used command buttons to jump back and forth between forms. Generally, the form works fine, but occasionally it will stall. Ctrl+break highlights the uf####.show as the stop point whenever it stalls. Here is the sample code used jumping back and forth between userforms.

Please Login or Register  to view this content.

I found some references to where showing a form from within a form is bad practice, but haven't found a better way to accomplish what I want. I can't unload the forms because I need to keep the information as I jump back and forth.

Do you think a multi page userform would work for you?

I don't think it would work because of the majority of the users limited knowledge with excel. I built the program to work as a step by step process and didn't think the multi-page was intuitive enough. The main form has 5 different sections that all lead to different forms.
Sorry for the long winded reply.

Have you tried declaring the information that you need in the form of a variable as part of the userform initialize procedure. After you have the variables and associated data stored in the second userform you can unload the first. If you have to keep going back and forth between the 2 then you should either make it 1 form or structure it differently

No I haven't, I need to be able to adjust the information on the fly. I'm just using the userform to auto-populate forms that I have generated in excel. But to the everyday user, excel is completely hidden and the only things they see are the userforms. The excel formats I have generated are a strict military forms that I've recreated in excel.

I was able to solve the userform stalling issue. I isolated the problem to utilizing the "X" to close a form. My initial code was a UserForm_Terminate Sub to control what happened for this situation. I adjusted all of my code to:

Please Login or Register  to view this content.

I haven't experience a single freeze/stall since. Hope someone can find this fix useful.