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?