Filter the names by combobox value.

[asyamonique]

Dim ws As Worksheet, rngFind As Range
Set ws = ThisWorkbook.Sheets("staff")
Set rngFind = ws.Range("i:i").Find(what:=Me.ComboBox2.Value, MatchCase:=True)
If Not rngFind Is Nothing Then
Me.TextBox20.Value = rngFind.Offset(0, 1).Value
Me.TextBox21.Value = rngFind.Offset(0, 2).Value
Else
Me.TextBox20.Value = "Not Found!"
TextBox21 = ("")
End If

Good Day,
Is it possible to alter given code to make it more functional like if the user wanted search the staff name with second name or 3th in the same cell?
Many thanks.

 

[asyamonique]

i think its not possible...