LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delays trans Excel Discussion (Misc queries) 1 January 24th 08 06:27 PM
Shortcut Key Delays [email protected][_2_] Excel Discussion (Misc queries) 0 November 29th 07 11:21 PM
Excel Delays TomXYZ Excel Discussion (Misc queries) 1 January 13th 05 12:19 PM
delays in macros Matt Dunbar Excel Programming 2 November 25th 03 01:28 PM
delays in macros Bob Phillips[_6_] Excel Programming 0 November 25th 03 01:02 PM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"