Excel VBA- Time delaying macro
 

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

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

Thanks for help

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

Excel VBA- Time delaying macro
 

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/

Excel VBA- Time delaying macro
 

This example pauses a running macro for approximately 10 seconds.

newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 10
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime

------------
That was copied directly from VBA help. Search for the 'wait' functio
to find out more.

-Gitcyphe

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

Excel VBA- Time delaying macro
 

Bob,

Could you tell me your email?


Bria

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

Excel VBA- Time delaying macro
 

bob . phillips @ tiscali . co . uk

without the spaces

--

HTH

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

"bsmith1 " wrote in message
...
Bob,

Could you tell me your email?


Brian


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