by bolpx001 » Wed Jul 09, 2008 5:36 pm
Hi All
I am wondering if anybody knows where I can find a list of the times goals are scored in a series of matches like say the premiership. I want the info to see if an idea I have is viable. An example of the sort of thing I am looking for is:
34 minute ManU
53 Minute Bristol
58 Minute Bristol
87 Minute ManU
Result Draw 2 2
As one good turn deserves another I would like to share a VBA command I make use of a lot, it is the Application.OnTime command and basically it allows macros to be run at set intervals
Sub two_sec()
' insert your own code here
' gets current time
nowTime = Now
' Sets PC to run macro two_sec in 2 seconds
Application.OnTime nowTime + TimeValue("00:00:02"), "two_sec"
End Sub
best regards – Paul