kindoflame
New Member
- Joined
- Feb 17, 2025
- Messages
- 4
- Office Version
- 365
I want to make a button and put it on a cell so that when I click the button that cell increases by 1. Easy enough; Developer tab -> Insert -> Button - >Place on correct cell -> Assign Button the macro below.
And it works perfectly! Exactly what I want it to do. However... I have like a hundred cell I want to put similar buttons on. Using this method, I would have to make a new macro for each button and make sure each button is paired with the right one. It is certainly possible, but it would be such a pain to do. There has to be an easier way, I just have no idea what it would be. If anyone can offer me some help, I would be very grateful.
VBA Code:
Sub AddTally()
Range("G9").Value = Range("G9").Value + 1
End Sub
And it works perfectly! Exactly what I want it to do. However... I have like a hundred cell I want to put similar buttons on. Using this method, I would have to make a new macro for each button and make sure each button is paired with the right one. It is certainly possible, but it would be such a pain to do. There has to be an easier way, I just have no idea what it would be. If anyone can offer me some help, I would be very grateful.