I have a spreadsheet that I use to keep score in darts (cricket).
I want to automate the scoring in it based on the selected player column.
For example:
I have a score card that is 6 players (columns) wide and 8 rows high (20-15 decending, + bullseye and score box). On the left they are labeled with their respective number associated with the target number on the board.
Then to the left I have a matrix that is 3 wide representing Single Double and Triple scoring for each of the numbers 20-15 descending and bullseye. This is where I want to program the buttons to effect the scoring chart.
In the workbook I want to click on the player name at the top of the column who is currently up. Then click on a button in a chart that would score based on the darts thrown in their turn. i.e. I hit a double 20 on the actual board and click the button that represents the double 20 on the chart and I want it to increment the scoring under the selected player (column) next to the 20 by 1 until it reaches 3 (being closed).
In addition I want it to also stop incrementing at 3 and then add the 20 (or whatever associated number) to a score box at the bottom of that players's column.
If anyone plays darts and knows cricket you will be better to understand what I mean.
This is a little complex, but I think possible.
Thanks in advance!
Chris
I want to automate the scoring in it based on the selected player column.
For example:
I have a score card that is 6 players (columns) wide and 8 rows high (20-15 decending, + bullseye and score box). On the left they are labeled with their respective number associated with the target number on the board.
Then to the left I have a matrix that is 3 wide representing Single Double and Triple scoring for each of the numbers 20-15 descending and bullseye. This is where I want to program the buttons to effect the scoring chart.
In the workbook I want to click on the player name at the top of the column who is currently up. Then click on a button in a chart that would score based on the darts thrown in their turn. i.e. I hit a double 20 on the actual board and click the button that represents the double 20 on the chart and I want it to increment the scoring under the selected player (column) next to the 20 by 1 until it reaches 3 (being closed).
In addition I want it to also stop incrementing at 3 and then add the 20 (or whatever associated number) to a score box at the bottom of that players's column.
If anyone plays darts and knows cricket you will be better to understand what I mean.
This is a little complex, but I think possible.
Thanks in advance!
Chris
