Use button to add 1 to total

[ruben2091]

Hello,
I need to add a button to my worksheet that adds 1 to the total when
clicked. For example, there will be a cell showing a total of 0, but I need
it to increase by one everytime I hit the button.

Thanks

 

[AltaEgo]

After you add your button, right-click the button
click view code
add the following on the line before 'End Sub'

Const YourCell = "A1" 'change
Range(YourCell) = Range(YourCell) + 1

 

[ruben2091]

Thank you so much Steve. That worked.

After you add your button, right-click the button
click view code
add the following on the line before 'End Sub'

Const YourCell = "A1" 'change
Range(YourCell) = Range(YourCell) + 1