Hi,

I have following data in a column (B):

C02/2401
C02/2801
C02/2401
C02/2801
C03/1015
C03/1006
C03/1015
C03/1006
C03/1006
C03/1015
C03/1015
C03/1006
I am wondering if it is possible to remove duplicates in the list and load unique and sorted values to a Combobox placed on a VBA form.

thanks