Max size of user form?

B

Brian

Can anyone help me with this question?

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?
 
C

Chip Pearson

Are referring to the size to mean dimensions (height, width) of the
userform, or the size of the modules that contain the code and its
controls?

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Brian

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. I have 12 GB of Memory, so
how can I run out?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the Limit of Text Boxes & Labels a User Form can have? 14
How do you resize a Multi Page User Form? 16
Excel VBA - Problem with Closing Print Preview 0
Create Fillable PDF Forms With LibreOffice Writer 3
Send Anywhere or similar program ? 8
Dynamic scroll bar max limit 2
MAX and Min value 2
Parts for my new build 10

Top