Filter Using User Form & Display the Whole Row of the Search Result on the Text boxes

Morning everyone,

I am still a newbie in Excel so I would like to request your help in solving a problem. Currently I am working on a data entry form for CRM database using Excel. Now i am stuck at filtering and displaying the data from the spread sheet to the user form.

There are three text boxes to key in the filter criteria and a button which will filter the data from the spreadsheet based on the criteria in the three text boxes. Then the whole row where the filtered data resides will be displayed on text boxes on the user form.

Your help is much appreciated. Thank you.

Sorry for being vague. The form is indeed UserForm1.
User needs to enter two keywords into two textboxes, criterion1 and criterion2 (the two text boxes at the bottom) and by clicking on the Search button, the form will search the spread sheet for cells containing the keywords and display the whole row on the text boxes and combo boxes inside the group box labelled "Organizational Detail".

I was planning to include another text box, criterion3 so that the user can filter results using up to three key words.

Hi HaHoBe,

Thank you very much for the link. It helps to solve my problem ^^