Excel Crashing when loading Form

[bhodge10]

Hello, I've created a quote template in Excel and for some reason my excel file will sometimes crash (at random uses of file) when switching from Form 2 to Form 3. With the below code, it closes Form 2 and then shows Form 3. But when Form 3 is activated, the code in the attached txt file runs. I don't know where exactly the program crashes, but somewhere between these 2 sets of code, Excel will completely crash. The strange part is, it does not happen every time the code is run. It happens at completely random times, but it is always when going from Form 2 to Form 3. The first section of code is below, this switches the forms from Form 2 to Form 3. Due to size, I've attached the code for when Form 3 activates. Any idea why it crashes? Thanks.

Please Login or Register  to view this content.

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[romperstomper]

Does it crash on the first occasion of switching to the other form, or have there usually been a few switches back and forth first?

[bhodge10]

Does it crash on the first occasion of switching to the other form, or have there usually been a few switches back and forth first?

It can happen to both scenarios. Once a particular file starts crashing, it will always crash, however we've noticed that we can "fix" the file and prevent it from crashing. There are multiple frames and within each frame there are checkboxes. We've noticed that if we check and uncheck any of the boxes within the frames it could fix the file. The way we know is if we check a box and it takes a couple of seconds to register, then when we go to Form 3 it will not crash. If the selection of a checkbox is instantaneous and we try to go to Form 3, it will crash. So users will just keep checking and unchecking random check boxes until it takes a couple of seconds to register, then they know they've "fixed" the crash and can move to Form 3. Hopefully that makes sense.

[snb]

I never found any reason to use more then 1 userform.
Did you explore the option of using a multipage in a userform ?

Besides, I amended the code you posted:

Please Login or Register  to view this content.

There's a lot more to improve the code; for instance:

instead of:

Please Login or Register  to view this content.

use:

Please Login or Register  to view this content.