Place a "U" then quit the entire macro

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

Place a "U" then quit the entire macro

Postby thonggruss » Tue Jun 17, 2008 8:51 am

Hi

I start learning VB after i start BA, i have the basic idea but not pro, i wrote a code but it makes my sheet very busy. can somebody make it to more efficient?

My basic idea is, when the sheet is updated and go in-play, then place a "U" to update my balance, after that quit the entire macro. i use z41 to control the update but is there any better/pro codes? (start from A41)

thank you


Private Sub Worksheet_Calculate()

If Sheets("1").Range("A41").Value <> Sheets("1").Range("z1").Value Then
Sheets("1").Range("z1").Value = Sheets("1").Range("A41").Value
Sheets("1").Range("z41").Value = 0

End If

If Sheets("1").Range("z41").Value = 0 Then
If Sheets("1").Range("e42").Value = "In Play" Then
Sheets("1").Range("z41").Value = 1
Sheets("1").Range("t45:t80").ClearContents
Sheets("1").Range("j42").Value = "U"

End If
End If

End Sub
thonggruss
 
Posts: 96
Joined: Mon Jan 29, 2007 1:42 am

Return to Discussion

Who is online

Users browsing this forum: Bing [Bot] and 17 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.

cron