Remove Combobox Duplicated items

Howdy. i have the code for adding items to the combobox based on the combobox text though would like to remove duplucated items

This is what i have (thanks to mikerickson)

Please Login or Register  to view this content.

Ive found this and cont figure out how to merge it in

Please Login or Register  to view this content.

Cheers

D_Rennie
If it works it looks good

there are some issues with the way it interract with the matching text for the search.
i think by removing the duplicates after running

Please Login or Register  to view this content.

all its doing is repopulating the list with the nodupes.
not to sure how to go about it.
I though of doing it in two parts run the nodupes to paste the items into another sheet column and then run the (up there part) using sheeet two for the range.

Also i have the loop match search incorrect.

Please Login or Register  to view this content.

I feel as if im getting close though.