Reload quick pick list at midnight

[GaryRussell]

This example uses the -3 trigger to reload the quick pick list followed by the -5 trigger to select the first market in the list. Both triggers go into cell Q2.

https://www.gruss-software.co.uk/Excel/ ... ckList.xls

1) When the workbook is opened the Workbook_Open event is fired. The Application.OnTime function is then called to run a procedure at midnight every day.

2) When the procedure runs at midnight it sets a flag telling the Worksheet_Change event to populate cell Q2 with -3.

3) Another flag is set telling the Worksheet_Change event to populate cell Q2 with -5 on the next refresh.

Press alt-f11 to view the code.

[GaryRussell]

Here is an example for multiple worksheets. It will load the UK horse racing win markets in sheet1 and the place markets in sheet2.

https://www.gruss-software.co.uk/Excel/ ... _multi.xls

Note workSheetCount in module1 and the worksheet number in brackets next to triggerQuickPickListReload and triggerFirstMarketSelect on sheet1 and sheet2.