Combobox change event not working with date change

[arihan1511]

I have a database showing visitor names in Column B and their visit date/time in Column A

Private Sub ComboBox1_Change()
    For Each Cell In Range("A1:A10")
        If Cell.Value = Me.ComboBox1.Value Then
            Cell.Offset(0, 1)..Select
        End If
    Next

End Sub

.I am trying to select visitor name in column B by date and time value in column A using a combobox change event which displays date and time.But its not working.Any help in this regard will be highly appreciated
Sample file and code is attached

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[arihan1511]

Its working Fine.Thanks so much.....