On Jan 6, 11:50*am, "Jon Peltier"
wrote:
I've gotten into this problem with around 250 textboxes. Instead of
multipages, make separate forms. Also, if you have more than even a couple
dozen textboxes on a form, I can't imagine it being easy for a user to use.

As Bob suggests, reconsider the design.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.http://PeltierTech.com/WordPress/
_______

"Scarlett" wrote in message

...

I am reading in some data from excel into a UserForm. There is a lot
of data organized on many different MultiPages.

When I add more than ~1024 textboxes on my UserForm, I get an "Out of
memory" error when I try to edit the code. I don't think that it is
related directly to just text boxes (if I have 1020 textboxes and 10
checkboxes I get the same error).

I read somewhere that the UserFrom objects are all public? Is this the
cause of the limitation? Is there a way around this? Can I nest one
UserForm within another? Can I increase this limit?

Thanks

Jon,
The userform currently has several tabs with an array of textboxes
(24x7) in each one. The user will not be modifying all 168 boxes on
each tab, but will need to selectively alter a few of them. I am
willing to sacrifice allowing the user to alter any of the text boxes
in the "parent" form if I can in at least display the values as a
(24x7) array in tabular form (maybe as labels?) and then have a
separate "edit" button that will open a new userform for them to edit
them there ... upon completing that form the data would be re-
populated back to the "parent" userform.

Does that seem possible?

Scarlett