Populate Listbox with Alphabeticized list

[jomili]

I have the below code to populate my list box. Trying to figure out how to sort the values put into "a" so they're in alphabetical order. Any help would be appreciated.

Please Login or Register  to view this content.

[CK76]

There's few ways to do this.

1. Create temp sheet, sort and then load to ListBox - This is by far the easiest method
2. Use bubble sort or other algorithm to sort array. Or if it's single column, use ArrayList and use it's sort method. Then load to ListBox.

It would help if you can upload sample workbook.

[YasserKhalil]

Try this

Please Login or Register  to view this content.

[jomili]

I found a solution and came back to find an almost identical one. The difference is the sorting macro used.

Please Login or Register  to view this content.

Thanks for helping!

[YasserKhalil]

You're welcome. Glad I can offer some help