+ Reply to Thread
Results 1 to 2 of 2

Error 28 Stack Space

  1. #1
    Forum Contributor
    Join Date
    07-27-2012
    Location
    Somerset, Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    123

    Error 28 Stack Space

    I am getting an Error 28 Stack Space error.

    Here is my code. The last part of the code "Decide which form to open" is where the error occurs. The file is set up as a survey and it walks them through questions pulling up userforms. This error happens at various times.

    Please Login or Register  to view this content.
    Last edited by scrabtree23; 10-26-2015 at 03:07 PM.

  2. #2
    Forum Contributor
    Join Date
    07-27-2012
    Location
    Somerset, Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    123

    Re: Error 28 Stack Space

    My problem was that this file starts by pulling up a userform with various options on it which all lead to another userform with options that lead to another userform etc. etc. etc. Eventually, the Call Stack would fill. I resolved this by using an Unload userform code every time there was a transition from one userform to another. Immediately following the Unload code each time I added the following code:

    Please Login or Register  to view this content.
    That set a timer to run the module "nextq.nextq" without an actual time delay. The "nextq.nextq" module loads the next userform. The "End" command "steps out of the code" and resets the stack.
    Last edited by scrabtree23; 10-27-2015 at 04:40 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Out of Stack Space Error 28
    By alexcapewell in forum Excel General
    Replies: 9
    Last Post: 10-13-2015, 07:01 AM
  2. Out of stack space error
    By lazyengineer in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-10-2015, 02:24 PM
  3. [SOLVED] Run TIme Error 28: Out of Stack Space
    By smciesl2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2014, 01:21 PM
  4. Run Time Error 28: Out of Stack Space
    By Shanahan0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2013, 10:42 AM
  5. Run-time error '28' Out of stack space
    By pinkpantherksa in forum Excel General
    Replies: 1
    Last Post: 12-13-2012, 06:33 PM
  6. Out of stack space error
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-20-2008, 03:47 PM
  7. [SOLVED] 'Out of stack space' error on SaveAs
    By Tim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2005, 01:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1