OssieMac,
I've got a copy of the userform that Brian is speaking of. Right now there
is no code associated with it at all. Attempting to open it from the VB
Editor (or from a simple UserForm1.Show command in a one-line Sub) causes an
Out Of Memory in Excel 2003 and/or 2007 under both Vista and Windows 7.

I took the form and deleted the 4th page and it opens with no problem. I
then duplicated the userform (with another name), loaded it into the file,
deleted the 1st 3 pages from it and you can open both UserForm1 (3 pages) and
UserForm2 (the 4th page) without any error.

So I'm kind of down to thinking this is some type of system memory wall he's
run into. The form is LARGE: 785.25 x 1316.25w; the 1st 3 pages have a total
of 1,049 controls and that 4th page has another 587 controls on it for a
total of 1,636 when they are in a single UserForm.

Any insight anyone has to limits of pretty much any type associated with
UserForms would be appreciated. I've searched and searched and really
haven't found any hard numbers about it. But I may not be looking in the
right places.

Peter T mentioned the size of the frx file; the userform does have a graphic
of the corporate logo on each of the 4 pages, so that's probably adding to
the file size.

"OssieMac" wrote:

Hi Brian,

I will be interested if anyone has further comments on this.

It is more likely that you are calling code in a standard module from the
code in the form module and you have an error in the called code.

I have experienced strange errors returned as well as code just not running
when calling code from a forms module. If my memory serves me correctly I
have mentioned this to you one time before although the problem you were
having was under different circumstances.

Any code that you call in a standard module should be able to run on its own
from the standard module for testing purposes with only a few variables used
to provide dummy test data. The code used to set the dummy data can be just
commented out and kept in case you want it again for further modifications to
your project. Running the code in the standard module this way usually
returns the errors at the correct location so you can fix it. Also being able
to run it as a stand alone sub is an indication that you have reasonably well
structured code.


--
Regards,

OssieMac


"Brian" wrote:

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?