ScotyB,

There's a reason its good practice to name your controls and variables with easily recognized names. Leaving them as TextBox1, ComboBox2, etc is very confusing. I made a list of what is what and where it goes, then used that information for the submit button code:
Private Sub CommandButton1_Click()

'List of items, where they go, and what control they use
'Item           Column  Control
'Name           A       ComboBox4
'Date           B       TextBox1
'Core Skills    C       ComboBox1
'Topics         D       ComboBox2
'Comments       E       TextBox2
'Instructor     F       ComboBox3

    Dim NewRow As Long: NewRow = Cells(Rows.Count, "A").End(xlUp).Row + 1
    Range("A" & NewRow & ":F" & NewRow).Value = Array( _
        Me.ComboBox4.Text, _
        Me.TextBox1.Text, _
        Me.ComboBox1.Text, _
        Me.ComboBox2.Text, _
        Me.TextBox2.Text, _
        Me.ComboBox3.Text)

End Sub