Excel VBA how to search data from a date

[S5ON3E]

Hi,

I'm trying to do a research in a userform from a date, I can search from a word but can't figure out how to do it from a date. Like here in the picture, from the textbox I have to enter the date of birth then click search and then the looked for data would go in respective textbox. Can someone help me? Thank you

 

[Alex Blakenburg]

For just the find the date part see if the below helps. Most people seem to use the Find function but it has quite a heavy reliance on the date format, this option using "Match" is more forgiving.
Not sure what you want to do if you have multiple rows with the same date though.

Sub FindDate_GetRow()

    Dim Sht As Worksheet
    Dim rowDOB As Long
    Dim rngDOB As Range
  
    Set Sht = Worksheets("Sheet1")      '<--- Change this to your worksheet name
    Set rngDOB = Sht.Range("D:D")
  
    With Application
        ' <--- Change this to use your text box values in DateSerial(yyyy, mm, dd)
        rowDOB = .IfError(.Match(CLng(DateSerial(2022, 5, 12)), rngDOB, 0), 0)
    End With
  
    If rowDOB = 0 Then
        MsgBox "Date not found"
    Else
        MsgBox "Drivers Permit: " & Sht.Range("H" & rowDOB).Value
    End If

End Sub

 

[My Aswer Is This]

Well I'm back I never like giving up.
When we look on the sheet how will we see the Date?

Will it be: 5/12/2022
Or will it be 5-12-2022
Or show me how it will look
This would be May 12 2022 in my example

But again have users enter dates can be tricky when then you want to search for date.
Easy want is to select date in Combobox or enter entire date in one TextBox