I would suggest the following instead to allow you to keep track of goals and behinds
C-like:
Sub T1GoalAdd()
Sheet1.[*goals cell*] += 1 // += is the same as saying variable = variable + x
CalcScores()
End Sub
Sub CalcScores()
Sheet1.[*home total score*] = (Sheet1.[*home goals*] * 6) + Sheet1.[*home behinds*]
Sheet1.[*away total score*] = (Sheet1.[*away goals*] * 6) + Sheel1.[*away behinds*]
End SubDoing it that way would allow you to more easily change score values AND force the sheet to recalculate every time the score changes. I don't know much VBA but this looks like pretty standard Visual Basic code which I am familiar with. You could do a nested function where each button passes the team, type of score and whether it is adding or subtracting, such as this:
C-like:
Sub ScoreChange(Home, Goal, Add)
If Home
If Goal
If Add
Sheet1.[*home goals*] += 1
Else
Sheet1.[*home goals*] -= 1
Else
If Add
Sheet1.[*home behinds*] += 1
Else
Sheet1.[*home behinds*] -= 1
End If
Else
If Goal
If Add
Sheet1.[*away goals*] += 1
Else
Sheet1.[*away goals*] -= 1
Else
If Add
Sheet1.[*away behinds*] += 1
Else
Sheet1.[*away behinds*] -= 1
End If
End If
CalcScores()
End Sub
Sub CalcScores()
Sheet1.[*home total score*] = (Sheet1.[*home goals*] * 6) + Sheet1.[*home behinds*]
Sheet1.[*away total score*] = (Sheet1.[*away goals*] * 6) + Sheel1.[*away behinds*]
End Sub
Code:
// home goal add
ScoreChange(True, True, True)
//home goal subtract
ScoreChange(True, True, False)
//home behind add
ScoreChange(True, False, True)
//home behind subtract
ScoreChange(True, False, False)
//away goal add
ScoreChange(False, True, True)
//away goal subtract
ScoreChange(False, True, False)
//away behind add
ScoreChange(False, False, True)
//away behind subtract
ScoreChange(False, False, False)Let me know if any of that helps - it can keep your program smaller than having one main function for similar tasks than having 8 separate functions. It also makes debugging easier in some ways because you only have one function to worry about or modify instead of 8.
EDIT: BigFooty doesn't preserve spaces or tabbing in spoilers so sorry about that.
Last edited:
It was more about could i do it without having to do research, which I was surprised i could, but i might dig out my old* C books
