I am creating a score card for the billards team and want to display a running score while a player is shooting. The process goes as follows
Special K's turn and on his first shot he scores 2 points-the score keeper enters a '2' in the player score column, focus stays on his player score cell (via VBA code)
a number 2 is entered in a cell to the right of the score card (say H1 for example)
Special K shoots again and score 3 points - a '3' is displayed in H2.
On special K's next shot he misses and does not score any points.
----------------------
the score keeper clicks on the playerscore cell for the next player (Banker)
At this time the "2" and "3" should be erased and now Banker's score will start to be shown in H1, H2, etc.
The requirement is to display a running score in column H for each player as their score is entered in their playerscore cell. when they miss, their running score is erased and the next players running score is displayed until they miss and then erase.
It seems to come down to when active cell changes (because I am keeping focus in the cell) or just recognizing that the user has clicked in a different cell but I've looked at a column change, current(active cell change) and cannot get the VBA to work.
How should I go about getting this to work?
Special K's turn and on his first shot he scores 2 points-the score keeper enters a '2' in the player score column, focus stays on his player score cell (via VBA code)
a number 2 is entered in a cell to the right of the score card (say H1 for example)
Special K shoots again and score 3 points - a '3' is displayed in H2.
On special K's next shot he misses and does not score any points.
----------------------
the score keeper clicks on the playerscore cell for the next player (Banker)
At this time the "2" and "3" should be erased and now Banker's score will start to be shown in H1, H2, etc.
The requirement is to display a running score in column H for each player as their score is entered in their playerscore cell. when they miss, their running score is erased and the next players running score is displayed until they miss and then erase.
It seems to come down to when active cell changes (because I am keeping focus in the cell) or just recognizing that the user has clicked in a different cell but I've looked at a column change, current(active cell change) and cannot get the VBA to work.
How should I go about getting this to work?
Left Team | Right Team | |||
Name | Player Score | Name | Player Score | |
Special K | Banker | |||
Gary | Bruce | |||
Doug | Gary | |||
Richie | Mike | |||
Team Score | Team Score | |||
Points 2 Go | Points 2 Go |