Search for comma-separated list of items

Hi everybody,

I need help with a text box based "VBA search engine" which looks for a list of comma separated items across a given workbook, highlights the occurrences and returns the number of occurrences back to the text box.

Thanks in advance for any help.

SearchTest.xlsm