+ Reply to Thread
Results 1 to 2 of 2

Macro Runs Multiple Copies of the Same Module By Mistake, & Gives Stack OverFlow Error

  1. #1
    Forum Contributor
    Join Date
    10-29-2019
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    156

    Macro Runs Multiple Copies of the Same Module By Mistake, & Gives Stack OverFlow Error

    Hi, for some reason my script isnt working correctly, it runs multiple copies of the same module for some reason.
    It also now gives a stack overflow error before it even starts ...

    The "init" module needs to be run 1st.

    How the script works

    Basically you type 1 in any column from a38 to v38, wait for 3 seconds & then type 1 again in another column, repeat for as many times as you want.

    The script launches a module everytime it detects a 1 is typed.

    I've attached the script too.

    Thanks.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Genus Max; 02-08-2020 at 07:01 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Macro Runs Multiple Copies of the Same Module By Mistake, & Gives Stack OverFlow Error

    It seems your code is looping every 3 seconds. What is the purpose of this loop ?
    - Battle without fear gives no glory - Just try

+ 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. Stack overflow? PLEASE HELP
    By lazyengineer in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-29-2015, 12:25 PM
  2. [SOLVED] Stack overflow
    By aadpors in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-27-2014, 11:05 AM
  3. Macro which opens workbook, runs macro, copies and then closes
    By Vihral in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2013, 11:45 AM
  4. Mistake in macro / VBA module
    By Marcel747400 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2012, 03:11 PM
  5. Keyboard Cell Delete Runs Into Stack OverFlow With Sheet Change
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2011, 06:30 PM
  6. Macro runs several times, but later crashes - some overflow Problem?
    By Reuel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2009, 11:59 AM
  7. Stack Overflow
    By DonHuff in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-07-2009, 03:30 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