Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use button to add 1 to total
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use button to add 1 to total
Thank you so much Steve. That worked.
"AltaEgo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
"Toggle total row" button not enabled in Excel 2003 | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |