CODEWITHSUNDEEP
vbaexcel
Andrei Ion
Andrei Ion

Reputation: 1827

Out of memory in Excel VBA

Here's the problem: I'm trying to make a small reporting tool. So... I have a MultiPage with about 8-9 pages and on every page there's another Multipage with 2-5 pages. On every page there are 8-10 comboboxes, about 6 textboxes and so on. It worked well 'till now when I tried to add another 5 pages in the last page to finish the program. Now when I want to compile it it says "Out of memory" From what I searched on Google it seems that the problem might come from the fact that the main Multipage stores too much stuff and too many controls. Some suggestions I saw were to brake the main Multipage... but I don't know how to design it to seem like a continuation of the main multipage Do you guys have any suggestions or do you know if there might be another reason why I get this error? Thanks a lot! https://i.sstatic.net/WnHRy.jpg to see the design ...lots of multipages and pages...

Upvotes: 0

Views: 4246

Answers (1)

Charles Williams
Charles Williams

Reputation: 23520

I suggest you try Rob Bovey's Code Cleaner http://www.appspro.com/Utilities/CodeCleaner.htm

And redesign your form into a series of separate forms that follow a logical sequence of choices and requested data. Once the user has made their initial choices you should not need to show them all the rest of your multi-multipage.
Also try using multiselect Listboxes for multiple choices.

Upvotes: 3

Related Questions