ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Continual addition to Cell (https://www.excelbanter.com/excel-programming/418588-continual-addition-cell.html)

Euan Ritchie

Continual addition to Cell
 
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

Gary''s Student

Continual addition to Cell
 
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
--
Gary''s Student - gsnu200807


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com