Here’s how to connect the macro to a button
Private Sub Button1_Click()
Dim val As Long
val = Application.InputBox(Prompt:="Enter Amount", Type:=1)
Range("C43").Value = Range("C43").Value + val
End Sub
12
solved excel popup button to ask how much money to add to an existing cell with an existing amount [closed]