Help with creating 3 macro buttons

[fsi]

Hello all! I needed help in creating 3 buttons within Excel that perform 3 separate, but simple functions.

1. The first button I need to add a single digit every time it is pressed. So if we click the button 4 times the number 4 is shown in a separate field.

2. The second button I need to add 2 every time it is pressed. If we click the button 4 times the number 8 is shown in a separate field.

3. The third button I need to add 3 every time it is pressed. So if we click the button 4 times the number 12 is shown in a separate field.

I appreicate the help.

Rick

 

[Diablo II]

try this

Sub button_1()
Range("A1").Activate
Range("A1") = 1 + Range("A1")
End Sub

Sub button_2()
Range("b1").Activate
Range("b1") = 2 + Range("b1")
End Sub

Sub button_3()
Range("c1").Activate
Range("c1") = 3 + Range("c1")
End Sub