Auto quick pick lists

[waynethebrayn]

Hi Gary,

In the latest version of BA is it now possible to update different quick pick lists in different tabs?

For example I have separate excel worksheets for UK horses & UK dogs, and trying to use VBA to auto refresh the quick pick lists as follows:

Public Sub refreshQuickPick()
Worksheets("UK HORSES").Range("Q2").Value = -3.1
Worksheets("UK DOGS").Range("Q2").Value = -3.11
Application.OnTime Now() + TimeValue("03:00:00"), "refreshQuickPick"
End Sub

However this seems to add the horse races to the greyhounds tab as well. I have not set any preferences in the options tab.

Thanks in advance.

Wayne

[GaryRussell]

Sorry, there is a problem which is fixed in the next release. You can download the next release using the following link.

http://www.gruss-software.co.uk/Betting ... _Beta1.msi

The triggers are slightly different, see below.
-3.1: All UK Win (Horse Racing)
-3.2: All UK Place (Horse Racing)
-3.3: All IRE Win (Horse Racing)
-3.4: All IRE Place (Horse Racing)
-3.5: All US Win (Horse Racing)
-3.6: All US Place (Horse Racing)
-3.7: All AUS Win (Horse Racing)
-3.8: All AUS Place (Horse Racing)
-3.9: All NZL Win (Horse Racing)
-3.11: All RSA Win (Horse Racing)
-3.12: All UK Win (Greyhounds)
-3.13: All AUS Win (Greyhounds)

[waynethebrayn]

Thanks Gary, I'll give it a try.

[xraymitch]

Gary,

I would like to have all UK and IRE Win (Horse Racing) in the Quick Pick List for one Excel worksheet, and all the UK and IRE Place (Horse Racing) in the Quick Pick List for a second Excel worksheet.

Had thought your excellent feature using cell Q2 triggers might have done this, but so far to no avail.

Am I missing something ?

Thanks in advance.

Ray

[GaryRussell]

Sorry, these new triggers do not support combining markets, you can add UK win or IRE win, but not both. I can quite easily add some more triggers to add UK and IRE combined though. I'll put it in the next release.

[xraymitch]

Gary,

I am flabbergasted - what else can I say ( don't you have a life ?)

You really are a Superstar - I know of no other software support that has such speedy responses !!

Many thanks,

Ray

[GaryRussell]

I have uploaded pre-release version 1.1.0.63 which includes two new triggers. Download using the link below.

http://www.gruss-software.co.uk/Betting ... _Beta1.msi

The new triggers are as follows.

-3.14: Load all UK & IRE Win Markets (Horse Racing)
-3.15: Load all UK & IRE Place Markets (Horse Racing)