Listbox with multi-columns what determines the order of the columns?

Userform multi-column listboxes.....what determines where the data will show up in the listbox(ie which column)?

If you take a peek at SearchInventory userform....run it and type in 99 red in the search textbox and accept the notice that there are several instances of 99 red.

You will see that the items that fill the listbox are not in the order that I would like for them to be in. (I labeled the columns above the listbox in the order that I would like to see them in)

BTW, I'm using an inventory searchable file that was posted yesterday by someone where royUK was helping them.

I think I have it figured out except for this.

This populates the ListBox

 With Me.ListBox1
                .AddItem c.Value
                .List(.ListCount - 1, 1) = c.Offset(0, -1).Value
                .List(.ListCount - 1, 2) = c.Offset(0, 0).Value
                .List(.ListCount - 1, 3) = c.Offset(0, -3).Value
                .List(.ListCount - 1, 4) = c.Offset(0, -2).Value
                .List(.ListCount - 1, 5) = c.Offset(0, 1).Value
                .List(.ListCount - 1, 6) = c.Offset(0, 2).Value
                .List(.ListCount - 1, 7) = c.Offset(0, 3).Value
                .List(.ListCount - 1, 8) = c.Offset(0, 4).Value
                .List(.ListCount - 1, 9) = c.Offset(0, 5).Value
           End With

Your code is actually filtering Column B, the initial search is on D

Thanks Roy,
I'll dig in there and look at that some more.

I need to go out but I'll post some amended code when I get back

Thanks Roy,

I got the Listbox column orientation fixed, but I noticed that I can't get the "delete" button to work. I added a bogus paint to my inventory and tried to use the delete button and can't get it to work correctly.

search, edit, save all seem to perform as expected....just the delete is acting up.

This sorts the listbox - your ColumnWidths were wrong, There seemed to be 10 entries for the 89 Column ListBox

The delete button is searching on the wrong column. When you click the listbox the textboxes do not populate correctly, you need to adjust them to match the columns in the listbox

Originally Posted by royUK

your ColumnWidths were wrong,
The delete button is searching on the wrong column. When you click the listbox the textboxes do not populate correctly, you need to adjust them to match the columns in the listbox

Check out post#5 and see if that file is better.(cols fill the listbox in the right order and widths were revised also)

Still can't get the delete button working though. It deletes out of the Listbox but the row with that info still remains on the inventory worksheet.