"Out of memory" error message

[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

 

[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