USERFORM THAT ADDS TO EXISTING CELLS

[billyshears]

Is it possible to create a userform that allows me to input a number into a box, and have that number added or subtracted into an existing cell.

For instance Lets say Cell A1 = 100

In my userform, I type in 10 and click a button.

Can that button make cell A1 = 110?

Thank you in advance

 

[Fluff]

Yes, you can use something like

Private Sub CommandButton1_Click()
   With Sheets("Sheet1").Range("A1")
      .Value = .Value + Me.TextBox1.Value
   End With
End Sub

 

[billyshears]

That worked! thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.