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

"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!

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


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