Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Delays
I have built macros with messages and input boxes. What I want to know is is
there a way to build a macro so that it runs to a particular points and stops -- then I do whatever I need to do for how ever long I need to do it -- then continue after I tell it to? Or do I have to build two seperate macros. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Delays
Depends what it is you want to do. If you just want to run to a certain
condition, and then break out and run some other VBA, just call the other macro. If you want to do something on a worksheet, you would probably be best to build a form and show it modeless so that the user can break out, but you don't control that. -- HTH RP (remove nothere from the email address if mailing direct) "Marco" wrote in message ... I have built macros with messages and input boxes. What I want to know is is there a way to build a macro so that it runs to a particular points and stops -- then I do whatever I need to do for how ever long I need to do it -- then continue after I tell it to? Or do I have to build two seperate macros. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Delays
There is no command to halt a macro and allow you to work free form on the
worksheet, then continue on. So two macros would be the way to go (probably). You might look at Chip Pearson's page on Application.OnTime http://www.cpearson.com/excel/ontime.htm if you only want to allow a set amount of time for the break between the macros, then this might be a workable approach. -- Regards, Tom Ogilvy "Marco" wrote in message ... I have built macros with messages and input boxes. What I want to know is is there a way to build a macro so that it runs to a particular points and stops -- then I do whatever I need to do for how ever long I need to do it -- then continue after I tell it to? Or do I have to build two seperate macros. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delays | Excel Discussion (Misc queries) | |||
Shortcut Key Delays | Excel Discussion (Misc queries) | |||
Excel Delays | Excel Discussion (Misc queries) | |||
delays in macros | Excel Programming | |||
delays in macros | Excel Programming |