Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add-in timing problem? | Excel Programming | |||
Advancing Timing | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Timing problem | Excel Programming | |||
VB timing question | Excel Programming |