Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: VBA Compile Error : Out of Memory

  1. #1
    Board Regular
    Join Date
    Oct 2010
    Posts
    450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA Compile Error : Out of Memory

    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

  2. #2
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    2,372
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Compile Error : Out of Memory

    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

  3. #3
    Board Regular
    Join Date
    Oct 2010
    Posts
    450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Compile Error : Out of Memory

    Thanks Derek

    I'll read through and hopefully resolve the issue

    A

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •