Cmd Btn to get sum

Question

I want to create a code for the command button in a UserForm I created so when I click the command button the sum of A3 + 1 will show up in A2.  What I have created below doesn’t work so well.  I don’t want to have any formula in A2, just the number value which is equal to A3 + 1.  Can you help? 

Private Sub CommandButton1_Click()

With Sheets("Sheet1")

.Range("A2").Value = A3 + 1

Unload Me

End With

End Sub

Answer 1

Try this version:

Private Sub CommandButton1_Click()

    With Sheets("Sheet1")

        .Range("A2").Value = .Range("A3").Value + 1

    End With

    Unload Me

End Sub

Answer 2

This is what I was looking for.  Thank you, it is perfect.