+ Reply to Thread
Results 1 to 2 of 2

Run a subroutine until another finishes, then stop that sub

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    87

    Run a subroutine until another finishes, then stop that sub

    Does anyone know how to run a subroutine (in this case a loop) until another separate sub has finished what it needs to do, then terminate the original sub?

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Run a subroutine until another finishes, then stop that sub

    VBA is a single-threaded language, which means you can only run one command/script/routine at a time. Therefore you cannot do what you propose. The closest thing would be to call the loop between each line of the other sub. i.e.
    Please Login or Register  to view this content.

+ 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. Best Method to Display 'Place' Finishes /w Appropriate Suffixes
    By ExcellentBill in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-14-2014, 09:16 AM
  2. Move to new sheet only when code finishes.
    By jad70 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2009, 09:29 AM
  3. [SOLVED] Macro finishes faster when left clicking during execution
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2006, 06:50 AM
  4. Breakpoint will not stop Excel subroutine
    By boswald in forum Excel General
    Replies: 2
    Last Post: 08-23-2005, 08:05 PM
  5. [SOLVED] Pausing procedure until worksheet finishes calculating
    By in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2005, 05:06 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