Userforms and memory issues

[fredrerik84]

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:

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

 

[kelly mort]

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]

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 ?