Syntax for arrays and loops in VBA

Hi,
I do not code in VBA very often and struggle with loops, so I am hoping that some gurus out there can help me.

I have a list in Excel and a form in my workbook. This form
1) enables a user to input a search string into a text box and click search
2) my VBA so far can take that input text and go to my list, search down all the text descriptions in each cell in column D
3) if it find the users text in a cell in column D, it copies that row out to a new workbook

so the result is the user gets a separate workbook with a list of rows where their search string is in the description text that was in column D of my list.

I want to expand my code to let the user input more than 1 search word and they can separate each word with a #.
I would like to understand how I can take the user input, use the # delimiter to separate each search string and when my code goes to each description in Column D is searches for each of these search strings rather than just one search string.

This is the code so far,

Please Login or Register  to view this content.

Looking forward to your creativity.

attach a sample file for testing