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