Search Function to search partial strings and return all matches

[rainx]

Hi all,

I am doing a program to retreive records.

Need help to search a partial string from Column L of "Data" sheet and return all matches in a combobox. User will type in the search criteria in A1 of "Sheet 2" and results should be displayed in the combobox for user to select which record to retrieve.

Appreciate any help.

Thanks!