I built a form to send information to the first available row in a spreadsheet. It worked great! Then I realized the tab button was moving through the form in the wrong order, so I rearranged the tabs. Now my form will not enter the data into the last row (or anywhere as best as I can tell).
Can you see anything I am doing wrong here? Please help and thank you for your time.

Here is the code for the form:

Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("LockClub-Sports")
iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
If Trim(Me.txtdate.Value) = "" Then
Me.txtdate.SetFocus
MsgBox "Please enter a date"
Exit Sub
End If
ws.Cells(iRow, 2).Value = Me.txtdate.Value
ws.Cells(iRow, 3).Value = Me.txtsport.Value
ws.Cells(iRow, 4).Value = Me.txtteam.Value
ws.Cells(iRow, 5).Value = Me.txtunit.Value
ws.Cells(iRow, 6).Value = Me.txtline.Value
ws.Cells(iRow, 7).Value = Me.txtbet.Value
ws.Cells(iRow, 8).Value = Me.txttowin.Value
ws.Cells(iRow, 9).Value = Me.txtwl.Value
ws.Cells(iRow, 10).Value = Me.txtwl2.Value

Me.txtdate.Value = ""
Me.txtsport.Value = ""
Me.txtteam.Value = ""
Me.txtunit.Value = ""
Me.txtline.Value = ""
Me.txtbet.Value = ""
Me.txttowin.Value = ""
Me.txtwl.Value = ""
Me.txtwl2.Value = ""
Me.txtdate.SetFocus

End Sub

Private Sub cmdClose_Click()
Unload Me
End Sub

Private Sub ComboBox1_Change()

End Sub

Private Sub UserForm_Click()

End Sub

form.JPGtab order.JPG