Asp Forum - Maximum Controls on UserForms - microsoft.public.excel.programming

Steve

12/20/2006 6:16:00 AM

What is the maximum number of controls that can held in a userform. I've got
a lot (several hundred) on one and keep getting a "Compile Error: Out of
Memory" message when previewing the userform. I began deleting controls until
the userform would preview successfully. Thanks.

2 Answers

Spreadsheet Solutions

12/20/2006 6:30:00 AM

I thought 128, but that might be wrong.
Anyway, stick to this rule, if possible.
Research has prooven that people are able to be aware of only 7 or 8
different pictures or objects on a paper.

So several hundred might scare them...

--
--
Mark Rosenkrantz
--
Spreadsheet Solutions
Witkopeend 24
1423 SN, Uithoorn
Netherlands
--
W: www.rosenkrantz.nl
E: contact@rosenkrantz.nl
--
"Steve" <Steve@discussions.microsoft.com> wrote in message
news:D2A811D1-7E9B-4263-A586-21DD600AD93F@microsoft.com...
> What is the maximum number of controls that can held in a userform. I've
> got
> a lot (several hundred) on one and keep getting a "Compile Error: Out of
> Memory" message when previewing the userform. I began deleting controls
> until
> the userform would preview successfully. Thanks.

NickHK

12/20/2006 7:03:00 AM

Steve,
I just made a quick test with 200 text boxes and 200 labels, which compiles.
However, whether several hundred controls is a good UI design is another
question.

What about using list box, list views, grid control etc instead ?

NickHK

"Steve" <Steve@discussions.microsoft.com> wrote in message
news:D2A811D1-7E9B-4263-A586-21DD600AD93F@microsoft.com...
> What is the maximum number of controls that can held in a userform. I've
got
> a lot (several hundred) on one and keep getting a "Compile Error: Out of
> Memory" message when previewing the userform. I began deleting controls
until
> the userform would preview successfully. Thanks.

microsoft.public.excel.programming

Maximum Controls on UserForms

Steve

Spreadsheet Solutions

NickHK

x Login to ForumsZone