Trouble shooting a user form code

[JO505]

I have tried to create a user form by adapting a U Tube lesson on user forms. So far the attached is what I have come up with but I cant get it to work. I think most of it is straight forward with some exceptions. I should also note that when it comes to VBA I know very little, just enough to get into trouble.

The data should paste to the log "Job" . Column "A" is blank, column "B" contains a ormula copied from the cell above the current entry, columns "C " thru "G" are populated from the form. Their are then a range of formulas that will be copied from the previous row, I just need to know how to code them. Can I just have a line of code that will enter the formulas as a range or will I need to write a line of code for each column?

Private Sub CommandButton1_Click()

eRow = Job.Cells(Row.Count, 1).End(x1Up).Offset(1.0)Row

    'Range("C2").Value = txtDate
    'Range("D2").Value = txtCustomer
    'Range("E2").Value = cmbJob
    'Range("F2").Value = txtNotes
    'Ramge("G2").Value = cmbPrice
    
    Cells(eRow, 2).Value = eRow - 1
    Cells(eRow, 3).Value = txtDate.Text
    Cells(eRow, 4).Value = txtCustomer.Text
    Cells(eRow, 5).Value = cmbJob.Text
    Cells(eRow, 6).Value = txtNotes.Text
    Cells(eRow, 7).Value = cmbPrice.Value
    
    

End Sub

Jim O