Need to alphabetically sort listbox.

I have a list box which draws from a sheet which by request of the user must be sorted by part numbers.

As a result, the mold numbers are not in alphabetical order.

If I sort by mold number, then naturally the part numbers will not be in order in my second list, which is populated with all part numbers that match the mold number selected in the mold list box.

So I need something which will pull all the mold numbers from an unsorted column, exclude duplicates, and then display in alphabetical order.



Currently I am using this, which I got from one of you helpful folks:

Please Login or Register  to view this content.

This works perfectly well, aside from the lack of sorting.

Originally Posted by bakerman2

You can BubbleSort a Dictionary or use a System.Collection.ArrayList instead which has a Sort Command.

Thanks, but to be blunt: I have no idea how to do such a thing.

If I am reading this correctly, this assume the combobox is on a worksheet. I guess I should have clarified that this is within a userform.

I imagine instead of sub demo() this then would be in the userform_initialize sub with the function placed elsewhere in the code sheet, and then I would have to change it simply to "combobox1.list" instead of "sheet1.combobox1.list" and set the range appropriately (I have a dynamic range set up for this)?

A lot of this stuff is new to me yet.

Originally Posted by shg

Please Login or Register  to view this content.