Results 1 to 3 of 3

Thread: Userforms and memory issues
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2017
    Posts
    383
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Userforms and memory issues

    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 by fredrerik84; Sep 30th, 2017 at 03:30 AM.

  2. #2
    Board Regular kelly mort's Avatar
    Join Date
    Apr 2017
    Location
    Suhum, Ghana, West Africa
    Posts
    1,509
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userforms and memory issues

    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

  3. #3
    Board Regular
    Join Date
    Feb 2017
    Posts
    383
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userforms and memory issues

    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 ?

Some videos you may like

User Tag List

Tags for this Thread

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
  •