.Cells (RowIndex, Column Using Header Name)

Hello, I am very VBA experience deficient and I've tried searching for some help but am stuck.

I'm making a user form, where there are ComboBoxes 1-10 (cmbProduct1, etc.) and TextBoxes 1-10 (txtProduct1Qty,etc.)

The user fills out the form and the quantities are stored in a "database sheet" organized by products as column headers. There are 40 Products, and 10 entrys on the form. So I need the 10 entrys to find their way to the right columns.

I need help matching the .Cells(RowIndex, ColumnIndex) based on the option selected in the combobox. I want to use a Header name, instead of a number here:

Sub SubmitInventoryLogger()

    Dim sh As Worksheet
    Dim iRow As Long
   
    
 Set sh = ThisWorkbook.Sheets("InventoryLogger")

    
    iRow = [Counta(InventoryLogger!A:A)] + 1
    
    With sh
    
        .Cells(iRow, 1) = iRow - 1
        
        .Cells(iRow, HELP HERE) = frmInventoryLogger.txtProduct1Qty
        .Cells(iRow, HELP HERE) = frmInventoryLogger.txtProduct2Qty
        .Cells(iRow, HELP HERE) = frmInventoryLogger.txtProduct3Qty
                ' etc... for up to 10 times. Sometimes they will be blank
                   
        .Cells(iRow, 3) = [Text(Now(), "DD-MM-YYYY HH:MM:SS")] ' this is the submit date time
    
    End With

End Sub

I'm to match the Qty for the Product Name on the Form to the corresponding Column in the Database Sheet.

i.e. combobox select Captain XTR, textbox "50" on the form -> I want the "50" to end up in Column T on the data sheet