Memory Issues with UserForms?

M

Marcolino

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
 
R

Ryan H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help required with 'FOR' Loop and Userforms 0
Memory problem: Userforms and ActiveX controls: How many is too many? 0
Memory problem: Out of Memory and cannot save 0
(reposting) Memory problem: Out of Memory and cannot save 0
VBE windows, zoom, ActiveX controls: Just one hit on memory, or many? 0
Memory issues with notes pages 4
2003 Crash and Drop Down Boxes 0
"Not enough memory" message 4

Top