Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]() In the same way that you can start a second sub from within a sub by using the command call mymacro is there a corresponding command to then stop that subroutine? Should be obvious but I'm struggling with the answer |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello teepee, Once a Sub is running it can be stopped either internally by the code checking for a certain condition, or externally by using the key combination *CTRL+Break* The break key may also be labeled *Pause*. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44651 |
#3
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
If you are running macroX and you want it to stop based on some condition If x then Exit Sub where x is the condition that triggers the macro to stop. If this helps, please click the Yes button cheers, Shane Devenshire "teepee" wrote in message ... In the same way that you can start a second sub from within a sub by using the command call mymacro is there a corresponding command to then stop that subroutine? Should be obvious but I'm struggling with the answer |
#4
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for the answers. Much appreciated
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
halt a subroutine question | Excel Discussion (Misc queries) | |||
How To Quit Subroutine from a called subroutine | Excel Programming | |||
Subroutine question and public variables | Excel Programming | |||
Halt recalculation | Excel Programming |