Userform Maximum?

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

Hello. I have a userform that has a ton of combo boxes and text fields.
(24 tabs of a multipage, with 50 or so boxes and fields per tab). I got to
4 tabs created, and loaded the userform to see how it was looking, and I get
a compile error: out of memory.

Is there a maximum amount of "stuff" I can put on a userform? And if so, is
there any way around it?!

Thanks!
 
AFAIK there is no limit to the number of controls on a userform - only a
memory limit of the client PC. You either need to increase memory or split
the form up.

Cheers
Nigel
 
Thanks Nigel. I have a pretty huge PC (2G of memory!!). You think
splitting the form up will work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform hides by itself 1
Multipage label caption 2
Maximum Controls on UserForms 3
Userform with 1024+ textboxes 13
Worksheet appears briefly before UserForm opens 4
modeless userform 4
Multipage control help 3
saving the userform layout 0

Back
Top