ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cell incrementing by a specific number (https://www.excelbanter.com/excel-programming/277889-cell-incrementing-specific-number.html)

andrewsheldon98

cell incrementing by a specific number
 
I Have the number 0 in cell A10 and would like a button to increment
this cell by 1 each time i click on it

Can some one help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


Don Guillett[_4_]

cell incrementing by a specific number
 

"andrewsheldon98" wrote in
message ...
I Have the number 0 in cell A10 and would like a button to increment
this cell by 1 each time i click on it

Can some one help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/




L. Howard Kittle[_2_]

cell incrementing by a specific number
 
Assign this macro to your button. Change cell address to suit.

Range("A1").Value = Range("A1").Value + 1

HTH
Regards,
Howard

"andrewsheldon98" wrote in
message ...
I Have the number 0 in cell A10 and would like a button to increment
this cell by 1 each time i click on it

Can some one help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/





All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com