Listbox column with different column cells

[ping0775]

Hi if i would like to selected certain cell column appear in the form listbox. how to write the code?

for example below code is coumn A,B,C will appear in the list box.
'.RowSource = "InvoiceDatabase!A3:C" & last_row

if i would like to choose certain column like column A , D , E etc.
possible?

 

[mikerickson]

The easiest way would be to load your data set and set the columns you don't want to 0 width

With ListBox1
    .ColumnCount = 5
    .List = Range("A3:E" & last_row).Value
    .ColumnWidths = ";0;0;;"
End With

 

[ping0775]

Thanks it works fine!! <3