I am not sure if this can be done but what I am attempting to do is to have the 4 areas above interact with the pitcher/batter cards on the left and right. The visiting batters card is always on the left with the home team pitchers card which will interact with the batters card sits next to it. The right side is the home team batter and the visiting team pitcher. These are all generated from a drop down list located in the "Lineups" tab using the Vlookup command to fill the cards in.
The Visitor/Home buttons let the excel sheet know which side of the screen the pitch dice and batters dice will be looking for. Depending on which button (Visiting or Home side) is in use the excel VBA command would then read the "pitch" dice first and locate the roll number matching it and highlight that area in yellow. The second dice "Batters" would then be rolled to find the result. In this case as you can see the roll of 27 would fall in the 2B area 24-27 under the "Tough" category and highlight that area. If the roll had been 10 (pitch) and 56 (Batter) then the line 10 - IN PLAY would highlight in yellow and since 56 is greater than any number under "IN PLAY" it would then highlight the G1 line and 54-61 under the out column.
Is it possible to tie all of this together (The Visitor/Home Pitch,batter and highlight sequence in one VBA code? Any help would be appreciated.
The Visitor/Home buttons let the excel sheet know which side of the screen the pitch dice and batters dice will be looking for. Depending on which button (Visiting or Home side) is in use the excel VBA command would then read the "pitch" dice first and locate the roll number matching it and highlight that area in yellow. The second dice "Batters" would then be rolled to find the result. In this case as you can see the roll of 27 would fall in the 2B area 24-27 under the "Tough" category and highlight that area. If the roll had been 10 (pitch) and 56 (Batter) then the line 10 - IN PLAY would highlight in yellow and since 56 is greater than any number under "IN PLAY" it would then highlight the G1 line and 54-61 under the out column.
Is it possible to tie all of this together (The Visitor/Home Pitch,batter and highlight sequence in one VBA code? Any help would be appreciated.