Auto count a cell

[dtallent]

I am tying to create a file in excel so that I can keep track of my daughter's volleyball stats. What I want to do is touch the screen and it will auto count, say it has 0, I touch the screen and it changes to 1, touch again and it goes to 2. I saw a macro that was created to allow the cell to change color, but I would rather it change to a number an keep counting as long as I touch he cell. Does anyone have a idea on how to do this? Below is the macro I found, but it just changes color.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'if cell fill is Blank, change to Brown
If Selection.Interior.Color = RGB(255, 255, 255) Then
Selection.Interior.Color = RGB(247, 150, 70)
GoTo Passem
End If
'if cell fill is Brown, change to Yellow
If Selection.Interior.Color = RGB(247, 150, 70) Then
Selection.Interior.Color = RGB(255, 255, 0)
GoTo Passem
End If
'If cell fill is Yellow, remove fill color
If Selection.Interior.Color = RGB(255, 255, 0) Then
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End If
Passem:
End Sub

 

[My Aswer Is This]

Well if you copied the same script into 5 sheets it should work on all sheets.

Show me the script your now using

 

[My Aswer Is This]

Glad you have what you want.

 

[dtallent]

Glad you have what you want.

Thanks. After all that I have discovered Excel on the ipad will not support VBA macros.

 

[My Aswer Is This]

Well you said this earlier:

I have it working perfectly. Thanks for your help. It was greatly appreciated.​

 

[dtallent]

Well you said this earlier:

I have it working perfectly. Thanks for your help. It was greatly appreciated.​

It works great on my laptop just the way I hoped, my ipad is a different story.

 

[My Aswer Is This]

Interesting. I have never used a ipad

It works great on my laptop just the way I hoped, my ipad is a different story.

 

[dtallent]

Interesting. I have never used a ipad

I have an ipad for work and use for more than just work. Thanks for your help though.