Excel VBA Form "Not enough system resources to display completely."

**1aaaaaaaaaaaaaaa** · 01-27-2015, 05:32 PM

Hello all-

I have a VBA application running in Excel that pulls data from an Access database and loads the information into a UserForm. The UserForm dynamically removes and then re-allocates the needed controls based on the amount of items listed in the data pull. The problem I am running into is that after a period of time (usually hours) the UserForm will fail to operate properly and/or crash with the message "Not enough system resources to display completely." Is there any work around or fix for this issue?

Thank you,

Will

**TMS** · 01-27-2015, 07:18 PM

Sounds as though you are creating and setting objects and not clearing them down again.

For example:

Please Login or Register  to view this content.

Ideally, when you finish with things, you should set them equal to nothing, in reverse order

Please Login or Register  to view this content.

A lot of the time it won't matter but if you are constantly looping and creating objects, it probably does.

Not easy to be more specific without seeing the code (ideally in a sample workbook)

Regards, TMS

**1aaaaaaaaaaaaaaa** · 01-31-2015, 07:31 AM

I've figured out what was causing the memory creep, the controls that were added (CommandButton / Label) still had their contents in memory after being removed using the 'Controls.Remove' method, specifically I was applying an icon image file to each row of buttons and a string to each label, by setting the CommandButton.Picture property to null and Label.Caption property to null I was able to eliminate the memory creep.

Please Login or Register  to view this content.

**TMS** · 01-31-2015, 12:03 PM

Thanks for the update. I'm sure it will raise awareness and benefit others in the future.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.