On Jan 8, 8:26*am, "Jon Peltier"
wrote:
With all due respect, you have no clue who you're talking to. If Bob
suggested to me that I redesign my project, I would go back to the drawing
board.

Sometimes it is necessary to redesign a project to redistribute the
complexity in such a way as to conform to the constraints of the tools used
in the project.

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

"Scarlett" wrote in message

...
On Jan 6, 8:26 am, "Bob Phillips" wrote:



How can anyone realistically use a form that has 1024 textboxes.

I think you need to re-design your project.

--
__________________________________
HTH

Bob

"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

With all due respect, some projects require a level of complexity that
you likely have not experienced.

I beg to differ. I think everyone has seen a million posts of the type
"why don't you rethink what you are doing?" without any further
explanation, no suggestions, no questions as to why they are trying
such a thing, nothing... that's just isn't helpful, no matter who they
are and it's even worse if they actually know a thing or two on the
subject and haven't helped out.