ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   quick code request (https://www.excelbanter.com/excel-programming/302237-quick-code-request.html)

Michelle

quick code request
 
Can anyone tell me a quick piece of code that will
increment cells h74, k74 and m 74 by 1 each time the
button is clicked?
Thanxxx Michelle

Papou

quick code request
 
Hi Michelle
Private Sub CommandButton1_Click()
[H74] = [H74] + 1
[K74] = [K74] + 1
[M74] = [M74] + 1
End Sub

HTH
Cordially
Pascal

"michelle" a écrit dans le message de
...
Can anyone tell me a quick piece of code that will
increment cells h74, k74 and m 74 by 1 each time the
button is clicked?
Thanxxx Michelle





All times are GMT +1. The time now is 11:46 AM.

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