+ Reply to Thread
Results 1 to 3 of 3

VBA out of stack space

  1. #1
    Forum Contributor
    Join Date
    03-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016 (among others!)
    Posts
    331

    VBA out of stack space

    I am looking to use worksheet_change to check a cell once it is changed and then carry out a series of processes on related cells if the cell in question is now blank. SO the idea is if the first column (B in this case) is blanked (it would usually show a date) then the value of a check box is changed (column R is where the linked cell is).

    The code is as follows:

    Please Login or Register  to view this content.
    This works fine if the cell contains anything. But if I edit the cell, remove the date and hit return I get an out of stack space error at the If stage. Is there a problem evaluating a blank cell or something?

    As always thanks in advance.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: VBA out of stack space

    The problem is that the code keeps calling itself, try disabling events.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    03-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016 (among others!)
    Posts
    331

    Re: VBA out of stack space

    Of course it does. Duh! My next step was to restrict the change checking to only column B which would of course sorted this as well. Some days are just like that! Thanks very much for your incredibly swift help.

+ 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. Out of stack space
    By Excel_vba in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2013, 01:06 AM
  2. Out of Stack Space
    By process in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-02-2012, 11:31 AM
  3. Out of stack space
    By papa jonah in forum Excel General
    Replies: 5
    Last Post: 04-13-2005, 06:06 PM
  4. [SOLVED] Out Of Stack Space
    By Momo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2005, 11:06 AM
  5. Out Of Stack Space
    By ianripping in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2005, 10:47 AM

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