Use button to add 1 to total
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
--
Steve
"ruben2091" wrote in message
...
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
|