Good Morning! I created a userform, with code on the {Submit} button that *should* populate the next blank row across 6 columns.
It is working for columns a,b,c but d,e,f do not seem to be getting the text that should be there. I spent over an hour last night trying
to troubleshoot this, but I am at a brick wall.

The code is:

Private Sub CommandButton1_Click()

ListRow = Cells(Rows.Count, 1).End(xlUp).Row
Set firstEmptyRow = Range("A" & ListRow + 1)

firstEmptyRow.Offset(0, 0).Value = TextBox1.Value 'Opp Name
firstEmptyRow.Offset(0, 1).Value = TextBox2.Value 'Create Date
firstEmptyRow.Offset(0, 2).Value = TextBox3.Value 'Book Date
firstEmptyRow.Offset(0, 3).Value = TextBox4.Value 'Poject Number
firstEmptyRow.Offset(0, 4).Value = TextBox5.Value 'Dollar Value
firstEmptyRow.Offset(0, 5).Value = TextBox6.Value 'Secured Margin Rate
End Sub


What am i missing?