Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum Controls on UserForms
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum Controls on UserForms
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: -- "Steve" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum Controls on UserForms
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" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum Controls on UserForms
I expect any limit with VBA userforms is dependent on a combination of
things besides simply the number of controls, events in the userform code module perhaps. (VB Forms I believe are limited to 254 controls if not in a ControlArray). Here's an example with 700 controls that the OP seemed to want http://tinyurl.com/yatwuu Regards, Peter T "Steve" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
Excel controls vs vba controls | Excel Programming | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Event procedures for controls added with Controls.Add | Excel Programming | |||
excel.exe error when adding controls to userforms | Excel Programming |