Prev: fill several sheets with data from other workbooks matching criter
Next: Existing File Not Found
From: Brian on 24 Mar 2010 22:26
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?
From: Chip Pearson on 25 Mar 2010 06:16
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



On Wed, 24 Mar 2010 19:26:01 -0700, Brian
<Brian(a)discussions.microsoft.com> wrote:

>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?
From: Brian on 25 Mar 2010 08:49
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?




"Chip Pearson" wrote:

> 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
>
>
>
> On Wed, 24 Mar 2010 19:26:01 -0700, Brian
> <Brian(a)discussions.microsoft.com> wrote:
>
> >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?
> .
>
 | 
Pages: 1
Prev: fill several sheets with data from other workbooks matching criter
Next: Existing File Not Found