Hello all, new guy here

I wish to make a scoreboard for the game of cricket. For those who may be unfamiliar with the game - player one aims at certain numbers (20, 19, 18, 17, 16, 15, bullseye) until he hits 3 of them, at which point, that number becomes 'open,' and any additional hit on that number results in points being scored. Once the second player hits 3 of that number, it is then considered to be 'closed' and no other points can be scored on it. The object being to close all numbers and have the highest total points.

Each dart for each round is being entered in, and I need two things: counting the number of marks for each player (easy), and using some kinda of if statement to determine if those marks should count for points if the other player hasn't closed that particular number (hard).

So my problem is one of timing. It doesn't just matter what number is hit, but when. So my question is, can this be done with a string of formulas, or would I be better solving this problem using VBA? I am fairly new to VBA by the way, but know some basics.



Thanks in advance for any help.