Edit search code criteria and rank results

I am currently using the following code to fill the list box lbSamDesc with the data in Column C on sheet EquipmentData where the adjacent B Column is blank. It then removes duplicates and alphabetizes the results.

Please Login or Register  to view this content.

I am trying to do something similar where rather than using the criteria of instances where adjacent Column B is blank, but rather it directly searches the contents of Column C with the text in text box 'ItemDescription'.
I will assign this code to a command button, so when the user clicks it will display all cases where the text in ItemDescription finds a match in Column C (doesn't have to be an exact match, it could just match one of, or part of a word, or string of letters in a cell). The results should remove the duplicates, and then be ranked so the most likely item is at the top (so basically cells with the most amount of matching words or string of letters appear first).
Thanks,
James