Search Engine VBA

Hi guys, eumm I need help for my search engine, yesterday i was asked for help about this search engine too and I already Solved it.
but there are still a bit problem here, and I have no idea how to solve it.

So i have a search engine like this
Screenshot 2023-05-17 145750.png
in this search engine whenever I try to searching data, I need to choose region then category which is this category based on column in my database and after I choose the category, I have to write the keyword to make the system search the data.
Screenshot 2023-05-16 152505.png

But i want to make like after I choose the region and I can write the keyword right away without have to choose the category, so whenver i write anyword in keyword textbox so it can search the data and found the exact data eventhough from the different column.

for example it can be like this,
Screenshot 2023-05-17 151541.png

I hope you guys understand, im sorry for my english

Thanks in advance

here is the file and code
TUTORIRAL SISTEM PENCARIAN.xlsm

I added a new command button to the userform, for testing. It has the code to find your item in column A:C.
It uses your same advanced filter code.

Check out the attached.

Private Sub CommandButton1_Click()
    Dim ws As Worksheet: Set ws = Sheets(Me.KANTORCABANG.Value)
    Dim col As Range, Lrng As Range
    With ws
        Set col = .Range("A:C").Find(what:=Me.KATAKUNCI, lookat:=xlPart)
        If Not col Is Nothing Then

            .Range("I1").Value = .Cells(1, col.Column).Value
            .Range("I2").Value = Me.KATAKUNCI.Value
            .Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
                                                      .Range("I1:I2"), Copytorange:=.Range("K1:Q1"), Unique:=False
            Set Lrng = .Range("K2:Q" & .Cells(.Rows.Count, "K").End(xlUp).Row)
            Me.TABELDATA.RowSource = Lrng.ADDRESS(external:=True)
            Me.HASILCARI.Caption = Me.TABELDATA.ListCount

        Else
            MsgBox "item not found"
        End If
    End With

End Sub

The code will not take into consideration if there is a chance surnames and first names are duplicate

thank you very much, I'll try the code.

first of all i would like to say thank you so much for the code, but eumm is it possible for me to find the data both in surname and firstname column also at different rows at the same time?, like this?
Attachment 830561
so when i write "jack" any column and rows that contain word jack will be show up ?? I've been looking for the answer and have tried many code but still failed. this is for my internship final project

Thanks in Advance