Search Date

[Av8tordude]

I have this code that finds the last airport in column G (which is SEA in the example below). In column B , I have various dates in column B . I would like to find the airport base on the date in txtDate (textbox)

Example: If the date in txtDate = 2/17/10, populate cboAirport with JFK

2/14/10 - ABE
2/15/10 - FLL
2/16/10 - JFK

2/19/10 - LGA
2/20/10 - LAX
2/21/10 - SEA

If Not RlsTime Then
    If txtRelease < "24:00" Then
        txtReport = "00:00"
        cboAprt = Range("G" & Application.WorksheetFunction.Max(11, Cur_Row - 1)).Value
    End If
    RlsTime = True
End If