Forum Discussion
excel scorer
HI newbie here
i am trying to make a dart score got all the basics formelas in .The question is
L7:l24 sum if l26 reaches 0 its add 1 to I8(legs) but when the sums clear l8 resets back to 0 ?
and the same with the avg cell and 180 cell?
have attach the file
cheers
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.
4 Replies
- anyone help?
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
