Using a Save button to copy particular cells

[joey_cava]

Hi,
I would like to use a save button where it captures particular cells on the user form and inserts them on a separate sheet with also reference to a particular cell. I have attached an example which is just a little extract on a big userform. Help would be greatly appreciated, even if it is some code to capture just one of the cells, than i can repeat the process for the remainding cells

[royUK]

Try to use correct terms,this is not a userform. It is a sheet acting as a form.

It's not clear what you want. Do you want to add values from the form to existing values? So if the form contains 5 & the data sheet has 10,the datasheet becomes 15

Option Explicit

Private Sub CommandButton1_Click()
    With Sheet1
        'move value,overwrite existing
        Sheet2.Cells(3, 3).Value = .Cells(3, 3).Value
        'add value to existing
        Sheet2.Cells(3, 3).Value = .Cells(3, 3).Value + Sheet2.Cells(3, 3).Value
        'clear form
        .Cells(3, 3).ClearContents
    End With
End Sub