count changes to a cell

[Strikk]

Hello,

I'm not sure if this is entirely possible but I'm trying to find a way to simply have cell count up by 1 everytime another cell changes value.

Eg//
Cell 1A has the formula =rand()*10
Cell 2A would add by 1 every time excel refreshes and changes the value.

Alternatively, if code doesn't register auto-calculations as a change, i'm happy for it to change on a manual input.

End goal is to count the amount of 'runs' that has occurred in a cricket match.
so every time you add a run to the score, a cell somewhere else is auto counting the amount of overs bowled.

 

[Joe4]

Welcome to the Board!

You should be able to use a Worksheet_Calculate event procedure to do that.

Right-click on the sheet tab name (on the sheet you want to apply this to) at the bottom of the screen, select "View Code", and paste this code in the resulting VB Editor window.

Private Sub Worksheet_Calculate()
'   Disable events temporarily so updated the count doesn't trigger to count itself
    Application.EnableEvents = False
'   Increment cell A2 by 1
    Range("A2") = Range("A2") + 1
'   Reenable events
    Application.EnableEvents = True
End Sub

 

[Strikk]

That worked thanks.
Thanks again for the prompt reply,

 

[Joe4]

You are welcome.
Glad I was able to help!