Baseball Heat Zone in Excel

[garyalarson]

Ok, I'm looking to create a grid that displays how well my hitters hit the ball based on the location of the pitch. (ex. Low/inside, they hit well...but up and away they hit very poorly). Is it possible to have some simple clicking of the cells to increase value of that field, then I can do simple conditional formatting to display intensity based on color.

Any help would be amazingly awesome!

 

[Weaver]

Right click the tab for the sheet you wish to use and choose 'view code' from the menu, then paste in the following:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Target.Value = Target.Value + 1
    [A1].Select
End Sub

This will increment whatever cell you double click on by 1

The [A1].Select bit moves the selection away from the current cell (assuming the current cell isn't A1) so that you can repeatedly double click the same cell. If you need to use A1, change it for something else, but make sure it's a cell that's always visible onscreen.

Hope that helps.