![]() |
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/ |
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/ |
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