Sam,
have a look at this site & see if heps you:

http://www.ozgrid.com/Excel/run-macro-on-time.htm
--
jb


"Sam" wrote:

Guys - trying to get the following subs to run every 10 seconds...i mean -
i'd just like to run sub master_trade every ten seconds but can't figure out
how to do it?


Sub Master_Trade()

Flip_Trade
Flip_Bid
Flip_Ask
STEP1
STEP2

Application.OnTime Now + TimeValue("00:00:10"), "Flip_Trade"
Application.OnTime Now + TimeValue("00:00:10"), "Flip_Bid"
Application.OnTime Now + TimeValue("00:00:10"), "Flip_Ask"
Application.OnTime Now + TimeValue("00:00:10"), "STEP1"
Application.OnTime Now + TimeValue("00:00:10"), "STEP2"

End Sub