stuck on the timing refresh....
Our latest posts crossed, glad I could help and thanks for the feedback.
Mike
"Sam" wrote:
It's working - got it...Thank you Mike...legend as usual.
"Mike H" wrote:
Sam
This goes in a general module
Sub Master_Trade()
Application.OnTime Now + TimeValue("00:00:10"), "Master_Trade"
Flip_Trade
Flip_Bid
Flip_Ask
STEP1
STEP2
End Sub
and to kick things off this goes in the workbook_open event
Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("00:00:10"), "Master_Trade"
End Sub
Mike
"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
|