Forum Discussion
excel scorer
SYMY77 The problem is that you aren't ADDING one but rather just displaying 1 or 0 based on the condition. In the format you have you need a macro to help you out. Alternatively you could have multiple games and track the progress across all the games/sets and then show total number of sets won and such then. That said, I helped you out and created 2 macros and 2 buttons: CLEAR ALL and NEXT SET. I also added some stuff at the bottom of the game board to track set wins and to keep a tally on the averages (because it sounds like you wanted the average to continue across multiple sets). If you want the #180 hits to track across sets you would have to add something similar for that also.
There are lots of improvements in style and function that are possible but I did it real quick to help you out. See attached.
SYMY77 The problem is that you aren't ADDING one but rather just displaying 1 or 0 based on the condition. In the format you have you need a macro to help you out. Alternatively you could have multiple games and track the progress across all the games/sets and then show total number of sets won and such then. That said, I helped you out and created 2 macros and 2 buttons: CLEAR ALL and NEXT SET. I also added some stuff at the bottom of the game board to track set wins and to keep a tally on the averages (because it sounds like you wanted the average to continue across multiple sets). If you want the #180 hits to track across sets you would have to add something similar for that also.
There are lots of improvements in style and function that are possible but I did it real quick to help you out. See attached.