I am trying to create a small userform call log.
The user takes details and on button click, the specified excel sheet will be populated with the text boxes.
I'm relatively new to VBA and cannot seem to populate columns on the current row (which should be empty) with the specified text boxes (e.g. column A = tb1.text, column b = tb2.text)
I have the "find empty row" working properly.
I have deleted the failed attempts at properly populating columns but need to keep the same format as this is being written in Visual Studio.

```
    Private Sub Button1_Click_1(sender As Object, e As EventArgs) Handles btn_submit.Click
    On Error Resume Next
    Dim objExcel As New Microsoft.Office.Interop.Excel.Application
    Dim objWorkbook As Microsoft.Office.Interop.Excel.Workbook
    Dim objWorksheet As Microsoft.Office.Interop.Excel.Worksheet
    objWorkbook = objExcel.Workbooks.Open("C:\_Private Data - NO BACKUP\Test OM Sheet.xlsx")
    objWorksheet = CType(objWorkbook.Worksheets.Item("Sheet1"), Microsoft.Office.Interop.Excel.Worksheet)

    Dim lastrow As Integer
    lastrow = objWorksheet.Cells(objWorksheet.Rows.Count, 1).End(Excel.XlDirection.xlUp).Row + 1
    Dim emptyrow As Integer = lastrow + 0,1
    objWorksheet.Cells(emptyrow, 0) = tb_date_time.Text
    objWorksheet.Cells(lastrow, 1) = tb_user_name.Text

    objWorksheet.Cells(emptyrow, 1) = tb_date_time.Text
    objWorksheet.Columns.AutoFit()
    objWorkbook.Save()
    objWorkbook.Application.DisplayAlerts = False
    objWorkbook.SaveAs("C:\_Private Data - NO BACKUP\Test OM Sheet Backup.xlsx")
    objWorkbook.Application.DisplayAlerts = True
    objExcel.Quit()

    Call reset_form()

End Sub

```