quick code request

[michelle]

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]

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

HTH
Cordially
Pascal