Filter a listbox with a combobox and seach button

Dear pros,

I need help with the attached small application please. Open the application and click on the LISTBOX button. I cannot seem to figure out the code for the Filter by Item button or the Filter by Representative button. I would like to select an item from either of those dropdowns in the search box, click on the relevant button and the list box will populate to show the results.

For example, if I were to select Chocolate Bars from the dropdown and click filter by item, I want to see only the three lines [i.e. line 2, 6 and 7] present in the listbox, and I want to be able to doubleclick on any of those lines to go to the record if I wish.

Similarly, if I select Robert from the other dropdown and click Filter by Representative, I want to see the relevant three lines [i.e. 4, 5 and 8] relating to Robert, present in the listbox, where I can again double click to go to the record [i.e. the data entry userform related to particular record selected.

I know it might be a piece of cake for some of you but I spent a very long time trying to figure out this code but with no luck.

I have attached a file for you to offer your coding magic!

Thanks for your help!


THIS HAS BEEN RESOLVED ALL. THANKS