Code help: Update new row of Table (ListObject) via UserForm

Hi guys,

i am trying to update a new row of a Table (ListObject) making use of a simple UserForm, but am struggling with the code.

i would really appreciate if someone could take a look.

See attached

Thank you in advance!

This seems to work:

oNewRow.Range(1, 4).Value = "Value For New cell"
oNewRow.Range(1, 5).Value = Me.TextBox1.Value

I was just going with the code you had provided. In what way do you intend to "reference a column name"?

One way:

oNewRow.Range(1, myTable.ListColumns("Column4").Index).Value = "Value For New cell"
oNewRow.Range(1, myTable.ListColumns("Column5").Index).Value = Me.TextBox1.Value

Or using ListColumns:

With myTable
    .ListColumns("Column4").DataBodyRange.Cells(oNewRow.Index).Value = "Value For New cell"
    .ListColumns("Column5").DataBodyRange.Cells(oNewRow.Index).Value = Me.TextBox1.Value
End With