You could look at incorporating an Ontime procedure driven by a button (look
in help).

Another way would be to use the windows timer. I have an example that you
can have if you email me. It has stop and start buttons.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"bsmith1 " wrote in message
...
Hi. I'm working on a macro that will take a row of cells (coming in from
live feeds), copy the values, and paste them one row down. I want to
store 40 periods of data. I want to be able to enter the number of
seconds that the code delays before repeating this process. I was
wondering if there is any time-delaying feature built into excel, and
how to program it so that it starts when i hit a button, and stops when
i hit another button...

The copying part is easy enough to program, but the time thing is what
is stumping me.

Thanks for help!


---
Message posted from http://www.ExcelForum.com/