View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AltaEgo AltaEgo is offline
external usenet poster
 
Posts: 245
Default 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