Memory Issues with UserForms?
 

I'm developing a VBA program that uses several UserForms.

As the program gets more complicated (and more UserForms are added), Excel
has started freezing/crashing on me - despite the fact that the file is small
(428 KB).

Is the freezing/crashing due to the number of UserForms (11 or 12)?

Could I avoid this problem by combining two UserForms into one and
displaying the controls associated with the two forms one at a time,
depending on which option is selected in the Main Form?

Any advice would be greatly appreciated.

Thanks

Memory Issues with UserForms?
 

I have an application with 20 Userforms, each has lots of controls and lots
of code to support those controls. I have no problems with freezing.

You may have some code that is causing a continuous loop, which gobbles up
memory very quick and may cause Excel to "freeze." You may have a huge
workbook with tons of sheets, images, or data that Excel has issues
computing. If possible, I'd post the code that potentially could be giving
you problems so we can help.
--
Cheers,
Ryan


"Marcolino" wrote:

I'm developing a VBA program that uses several UserForms.

As the program gets more complicated (and more UserForms are added), Excel
has started freezing/crashing on me - despite the fact that the file is small
(428 KB).

Is the freezing/crashing due to the number of UserForms (11 or 12)?

Could I avoid this problem by combining two UserForms into one and
displaying the controls associated with the two forms one at a time,
depending on which option is selected in the Main Form?

Any advice would be greatly appreciated.

Thanks