"Out of memory" error message

S

saiedeh nikraftar

I have a userform with a multipage which has 12 pages, each one has around 130 controls.
When I try to see the code I receive Out of memory error message and after that another error message: "member not found"
If I delete page 12 controls error solves but I need to have even more pages.
I don't think I hit the limit for the number of controls in a form.
I downloaded a toolbar to be able to check the spent memory in run time and when this userform is running , spent memory is just 1KB!

Any help?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Viewing Tech-Ed 2005 Content for Non-Attendees
http://www.eggheadcafe.com/tutorial...ca-a04feac064b2/viewing-teched-2005-cont.aspx
 
C

Charles Williams

Sounds like too many controls to me: I would find it hard to use a form with
130 controls.

You could try:
- breaking the form into 12 separate forms, each one called by the preceding
form
- replacing some of the 130 controls with a listbox or combobox

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 

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

Excel forms - hiding a group of controls 0
Error code 9305 1
Memory problem: Out of Memory and cannot save 0
System Error &H8004111 + out of memory when using Excel macros 2
(reposting) Memory problem: Out of Memory and cannot save 0
Error message 0x8007000E Out of Memory 0
Out of Memory Error 7 While assigning named range value 8
Out of Memory Error when calling Userform 2

Top