Continual addition to Cell

  • Thread starter Thread starter Euan Ritchie
  • Start date Start date
E

Euan Ritchie

I'm trying to make up a macro so that everytime i click "A" button a given
cell will count and display how many times the button has been pressed.
Thanks for any help in advance
 
After creating the button, assign this macro to it:

Sub qwerty()
With Range("B9")
.Value = .Value + 1
End With
End Sub

Adjust the cell to suit your needs
 
Back
Top