I'm trying to create a sheet that will maintain a running average of my score when I'm playing darts.
B2 = Where I input my score
B3 = Displays my average
B4 = +1 just gets added here everytime I click the button.
The part where I try to define B3 as being B2 + B3 / B4 is the problem.
Private Sub CommandButton1_Click() Range("B4").Value = Range("B4").Value + 1 Range("B3").Value = Range("B2").Value + Range("B3").Value / Range("B4") Range("B2").Select Selection.ClearContents Range("B2").Select End Sub
Bookmarks