Userform Listbox populate mulitple columns with unique values from one column

[sunjam]

Hi there,

Please help

I need to populate the listbox only the unique values from Column D

Please see my code below

With ListBox1
        .ColumnHeads = True
        .ColumnCount = 5
        .RowSource = "ILQ!C3:G30"
        .ColumnWidths = "150;450;40;40;30"
    End With

Thank you,

 

[Norie]

Why is the ColumnCount set to 5 if you only want to populate the listbox from one column?

 

[sunjam]

Hi Norie,

I need the 5 columns information and there are duplicates in Column D. Its like having a filter in Column D with unique values.

Thank you,