Tennis scoring macro

Code restructered to make it easier for you to amend
- when game placed summary procedure calls all the other subs
- each sub carries out one task
- sub name makes that pretty clear.

You have not explained where you are heading with this but if there are further developments in mind now is the time to ask for help- before I forget what I've done
From now on, its best if you revise the code - but I am happy to answer any questions.


Hopefully its pretty near the mark.
There are 3 logs
- LogScores = everything
- LogSets = every set
- LogMatches = single line summary of each match


Plus one enhancement - feature allowing games to be played automatically without having to keep pressing the "A" or "B" button - was useful in testing - so have left it for you
- uses random number generator to allocate points to A & B
- my computer simulated hundreds of games with various settings to test that VBA was making correct choices.
- all games played are based on the options selected by user
- suggest you try first with no more than 50 games to see how long it takes
- all games added to the 3 logs

Tennis4.jpg