Help with adding value (given in userform textbox) to value in worksheet cell

[rharri1972]

Hello! I cannot get my mind wrapped around this problem. I have userform 1 with textbox 1 that contains a numerical value that I manually type in.

On the click of a "SUBMIT" command button I want the operation to add this value entered to the value already in my worksheet ("Parts").Range("E2)

If this is possible my goal is this.

on click... let the value in textbox 1 be added to the value in cell E2.

ex: if the value in cell E2 = 15 and the value in textbox 1 = 5... with the click of the button the value in cell E2 updates to 20.

is this possible with VBA?

 

[Georgiboy]

Your command button code would be similar to the below:

Private Sub CommandButton1_Click()
    Dim val As Double
    
    val = Sheet1.Range("A1").Value
    Sheet1.Range("A1").Value = val + Me.TextBox1.Value
End Sub

 

[Fluff]

Duplicate to: Updating Cell value in worksheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.