Tennis scoring macro

see attached file
Here is a rough and ready starter for you to test
Let me have your comments and wish list
I have not include the 5 set option - will add later

This looks to be what i am looking for after testing.

One thing which would be good though is i am looking to create formulas based on the current score which would point to specific cells where the scores would be updating, hence if instead of a pop up the scores were just updated in the cells.

Thanks very much for this.

Wish list:

If when reaching either 3 sets of 5 sets it would revert to game over, and an option to select if it is a 3 set match or 5 set match would also be good.

An option to select if it a singles match or a doubles match would also be good as doubles rules are different see below:

In some doubles matches now (Not grand slam matches), if the score is 1-1 in sets, they now play a Match Tie-Break, which is exactly the same as a normal tie-break yet it is the first to 10 points and whoever wins this wins the match.
Also in these doubles matches there is no advantage, it is just whoever wins the next point when the game is at duece who wins the game.

Also - in grand slams there is no tie-break in the 5th set hence they just keep playing games until a two game margin.

So ideally an extra 5 buttons which can be ticked - 3 or 5 sets? Singles or Doubles? "Match-tie break" (Yes/No), "No Advantage" (Yes/No) and "Tie-Break 5th set" (Yes/No) based on the rules above.

Cheers and sorry if it is getting more complicated

David.