How do I create two buttons in Excel that I can name?

[sixela]

Hello! I am trying to create an increase button that I can name "increase" and a decrease button I can name "decrease". I cannot use the spin button since I need to name the buttons and I need to learn this skill for future work projects. I need buttons to increase and decrease cell B5. Any help is appreciated! Thank you

 

[alansidman]

Assign a macro to a Form or a Control button - Microsoft Support

Create a Form button or a Command button and assign a macro that performs an action when a user clicks the button.

support.microsoft.com

 

[jolivanes]

Two Buttons, one piece of code.
One Forms Control Button has the Caption "Increase" (no double quotes) and the other Forms Control Button has the Caption "Decrease"

Sub Add_Or_Delete()
Select Case ActiveSheet.Buttons(Application.Caller).Caption
    Case "Increase"    '<---- Same spelling as the text ( = Caption) on the one Button
        Range("B5").Value = Range("B5").Value + 1
    Case "Decrease"    '<---- Same spelling as the text ( = Caption) on the other Button
        Range("B5").Value = Range("B5").Value - 1
End Select
End Sub

 

[jolivanes]

Again, same restrictions for Button Captions.
Same code for both Buttons.

Sub Or_So()
    Cells(5, 2).Value = IIf(ActiveSheet.Buttons(Application.Caller).Caption = "Increase", Cells(5, 2).Value + 1, Cells(5, 2).Value - 1)
End Sub