View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scarlett[_2_] Scarlett[_2_] is offline
external usenet poster
 
Posts: 7
Default Userform with 1024+ textboxes

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