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.
- hi mtarler
Thanks for your help just learning excel
just what i needed. Didnt know it needed vba
i might be back to ask for your help again lol
Cheers- You're very welcome. Let me note that what you wanted needed VBA partly because how you set it up. Like I mentioned if you made a grid to show all 3 or 5 games that they would play then simple formulas could be used. I used VBA because you wanted it to remember values after you deleted them and even there I just used VBA to store those summary numbers before clearing all the other numbers. Best of luck (with Excel and darts)