24th May 2012, 03:53 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,432
|
|
Code:
Public triggerQuickPickListReload As Boolean
Public triggerFirstMarketSelect As Boolean
Public Sub loadQuickPickList()
triggerQuickPickListReload = True
Application.OnTime TimeValue("10:30"), "loadQuickPickList"
End Sub
This is a module in one of my workbooks that reloads the markets at 10:30am every day, so I can leave the computer running indefinitely without having to do anything.
It's all visual basic. |