VBA Compile Error : Out of Memory

[blossomthe2nd]

Hi Guys,

I have a doc that has about 7 Userforms to review a Process (A UForm per Product) .

It was decided to review this doc, as some of the Processes Run Inline with Each other , a User would need access to Multiple Userforms at once. I was going to create one Userform with 7 tabs . There is quite a bit of Code on each UF and about 200 Objects per Form Also.

When I Created My Master Userform a with 7 tabs and copied over all the Objects- even before I added any code when I try to run the UF I am getting an Error :

Compile Error : Out of Memory


( When they run as UFs in their own right there is NO issue)

I am looking to see either :

Why this is happening ?
Is there a Way around it ?

Any guidance or suggestions really appreciated


Thanks
A

 

[Derek Brown]

One of the following may be of help:
Excel compile error: out of memory
Out of memory in Excel VBA - Stack Overflow

 

[blossomthe2nd]

Thanks Derek

I'll read through and hopefully resolve the issue

A