Userforms and memory issues

fredrerik84

Active Member
Joined
Feb 26, 2017
Messages
383
Good morning. Ive been creating a couple of userforms and I notice that when I test all functions and changes I make I keep getting this error "out of memory" in my excel . I think the userforms are the issue.

Typically during testing , the userforms are loaded and unloaded a ton of times..

is this not correct command to clear them from memory:

Code:
Unload Me
or could something else be causing memory issues , maybe there is some way to check whats in use ?

hope anyone have some thoughts or ideas to help out a little ?

frederik
 
Last edited:

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

kelly mort

Well-known Member
Joined
Apr 10, 2017
Messages
1,734
Office Version
2016
Platform
Windows
It will help if you can post your code. Maybe your variables are causing the issue.
Then the system you using: 32 /64

Note:
installed memory size is also a factor.
Rgards
 

fredrerik84

Active Member
Joined
Feb 26, 2017
Messages
383
Hi thanks for your response

Maybe it could be the vars , but I dont have that many running only "dim as worksheet" and a few long vars
Its only when I do extensive testing of my code I get "Out of memory!" error

But I see that I dont set them as nothing when the userform is unloaded , maybe that could be the issue ?

Note:
installed memory size is also a factor.
I have a 64 bit system, with 32 gigs of ram.. so I don't think the problem could be in the hardware setup... But maybe it could be the 64 bit version of windows running ?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,753
Messages
5,446,308
Members
405,396
Latest member
SpiFF2000

This Week's Hot Topics

Top