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.