scoreboard macro problem

[Olargee]

hi there.. I'm not sure how the best way to phrase this is, but my problem is like this

I have a scoreboard from Cell A1 to A5

When I press a button the score number in Cell A1 increases by 1
I have managed to make a button that does this

How do I write the code to tell my button to increase the number in Cell A2 when a specific condition is met. Say for example.. the number in A1 is 10

And when cell A2 is at 10 I want the button to interact with cell A3 and so forth

Please help

Thanks in advance

 

[Jerry Sullivan]

Hello and Welcome,

Try this to get a feel for how If...then statements work.

Private Sub CommandButton1_Click()
    With ActiveSheet
        .Range("A1") = .Range("A1") + 1
        If .Range("A1") = 10 Then
            .Range("A1") = 0
            .Range("A2") = .Range("A2") + 1
            If .Range("A2") = 10 Then
                .Range("A2") = 0
                .Range("A3") = .Range("A3") + 1
            End If
        End If
    End With
End Sub

Not sure if you wanted to freeze the value at 10 when reached or reset to 0,
hopefully you can experiment with this to accomplish your task.