Hello Everyone,
I have a scheduling program with two userforms. One form adds five different pieces of data to Cells A to E on a row in a worksheet. This worksheet has many existing rows of data, each row as an unique set of info(There no duplicate entries of Date(Cell A) and Simulator session(Cell C), I have code to prevent this). This form works 100%.
Here is my trouble spot: The second form is for the schedulers to place names of Operators in these existing rows of data (cells H to J is where I want the data to go), What I want the second form to do is search an the existing rows on the worksheet, find a match based on two criteria; (Cell A)Date and (Cell C)Simulator Session. Then add the names of the operator(s) in the assigned columns in that same row.
Something to this effect:
If Userform(TxtDate) matches Cell A and UserForm(TxtSim) matches Cell C then add (Userform)TxtPilot to Cell 8 and userform(TxtNavs) to Cell 10 etc.

Here is the code I started but can’t get to work, When I click the submit add button the form runs and clears itself like I want but I can’t get the data to go where it should

 Private Sub cmdAdd_Click()
Dim iRow, row_count As Long
Dim i As Integer
Dim ws As Worksheet
Set ws = Worksheets("404ONLY")

For i = 2 To row_count
        If ws.Cells(iRow, 1,3).Value = Me.TxtDate.Value + Me.TxtSim.Value Then
        ws.Cells(iRow, 8).Value = Me.Txtpilot.Value
        ws.Cells(iRow, 10).Value = Me.TxtNavs.Value
        ws.Cells(iRow, 11).Value = Me.TxtAesops
        Exit Sub
    End If
Next i
'clear the data
Me.Txtpilot.Value = ""
Me.TxtNavs.Value = ""
Me.TxtAesops.Value = ""
Me.Txtpilot.SetFocus

End Sub
Any help would be greatly appreciated.
Glenness