Remove duplicates out of combobox

Count the number of times you've already encountered the value in your progress up the column ... if count = 0 , on rows already processed then add the current rows value (NOTE: the counting is be performed by excels "CountIf" worksheet function).

Please Login or Register  to view this content.

Open the sample workbook, click the show userform, I usually populate the combobox with the Userform_initialize code.
Anyway it looks like this, you also need to clear the ComboBox each time you populate it or it will just keep getting bigger.

Please Login or Register  to view this content.