There are Prob less than 1000 (Text Boxes, Combo Boxes, Labels, etc...).

I removed all the code and put it in a blank workbook and tried to run it
from the VBA window i get the same Error.



"Peter T" wrote:

The 64K was never a limit set in stone, in any case you've only got 34k.
I've tested forms with 1000+ controls without problems but 219K in the frx
does seem large (but depends more on what it is, eg definition of a picture
would make it large but merely basic control properties doesn't take much).
When you say "a lot" of controls what are you actually talking about.

Regards,
Peter T


"Brian" wrote in message
...
What is the Max File Size a User Form can be?

I have Windows 7 with Office 2007.

Does it have like a 64K limit?

The file size as far as kb. My entire Program is 1,203 Kb.

When I ran it I got a "compile Error out of memory", so I exported my User
Form. Then I looked at the file size of just the User Form in a blank
Workbook
34 KB = .frm
219 KB = frx

My user Form is a Multi Page with 4 Pages on it. There are alot of text
boxes and labels on the 4 sheets. Is there a limit to the number of text
boxes & labels you can have in a user Form?

I have 12 GB of Memory, so how can I run out?





.