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?
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?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks