View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Userform Maximum?

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

"Steph" wrote in message
...
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!