Keyword search function - user form

[cupid800429]

Greeting all,

I'm kind of lost try building the keyword search function in VBA User Form.

The keyword search function to work as following:

User select category by choosing the radio button and the selected list will appear (I managed to do this) --> user key in key word in the text box --> hit search button --> VBA to identify the key word for the group of items displayed in list box --> search in excel sheet (database) --> display all the codes contain the keywords in keyword search list box (something like Google search)

The file as attached.

appreciate your help regards the matter

Regards
VJ