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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top