Use button to add 1 to total

  • Thread starter Thread starter ruben2091
  • Start date Start date
R

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
 
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
 
Thank you so much Steve. That worked.

AltaEgo said:
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
Click to expand...
 
Back
Top