Q: I need a button on my Excel sheet that I can press just to increase the value of a specific cell by a set amount. For example, I have my total sales in cell B3, and each time I make another sale, I want to add $20 to this value. Sometimes it's $100. It's usually either 20, 50, 100, or 200. Sure, I could do it with the keyboard, but can I make a button I can just click on? - Kyle

A: Sure. You'll need to know how to access the VBA editor, but it's not hard. Let's say you want to make a button that adds 20 to whatever the value in cell B3 is. Just assign a macro with the following VBA code:

Range("B3") = Range("B3") + 20

That's it. Each time you click the button, B3 gets 20 added to it. If you want different dollar values, or you want to change different cells, you could just make multiple buttons.

Subscribe to Excel: Button to Change Value
Get notifications when this page is updated