How to Sum and update a specific cell that already has a value, with a Userform

[michaelroshan]

I have the following sheet witha Userform. and what i need to do is -
(1). I need the vba code to select a code from the drop down ComboBox. - (I Already figured it out)
(2). once the code is selected, i need to update the specific value of that row in Column "F" according to the code selected from comboBox. by adding to the already existing value. (Example: code "1" has value "250" in F2, and when i enter new value "100" in the TextBox, i need it to be added to the already existing value and show the new value as "350".
Please someone help me with this coding.
Thanks

 

[EXCEL MAX]

Hello Michaelroshan,
Start from this code...

Dim varComboValue As Range

Private Sub CommandButton1_Click()
    
    Set varComboValue = Range("A1:A10").Find(ComboBox1.Value)
    If Not varComboValue Is Nothing Then
        Cells(varComboValue.Row, 6) = _
        Cells(varComboValue.Row, 6) + UserForm3.TextBox1.Value
    End If
        
End Sub

 

[michaelroshan]

Hello Michaelroshan,
Start from this code...

Dim varComboValue As Range

Private Sub CommandButton1_Click()
   
    Set varComboValue = Range("A1:A10").Find(ComboBox1.Value)
    If Not varComboValue Is Nothing Then
        Cells(varComboValue.Row, 6) = _
        Cells(varComboValue.Row, 6) + UserForm3.TextBox1.Value
    End If
       
End Sub

Oh wow!
Many Many Thanks.. it works perfectly..

 

[EXCEL MAX]

You are welcome.