Display all columns in list box

[jpbisani]

I have taken this workbook from forum and made minor modification. I got stuck when I wanted all Columns to display in List box but it does not display more than 2. I wanted to dispaly 10 columns (from column 4 to 10 are not more than 8character), but when I add 7th column programe stops working. Request to share how to increase column display in Listbox.

Your help will be very much valued and appreciated.

[Andy Pope]

look at the columncount and columnwidth properties you have currently set. Change to suit your requirement.

Also the listbox is wider than the userform so even when all columns are loaded some may not be visible

[jpbisani]

Thank youAndypope