Sorting a Listbox

[Steve C]

I have a list box (lstProjects) on a user form that is populated by a text
file. I need help with code that would sort the listbox in alphabetical
order. Thanks for any assistance you can give me!

 

[Jean-Guy Marcil]

I have a list box (lstProjects) on a user form that is populated by a text
file. I need help with code that would sort the listbox in alphabetical
order. Thanks for any assistance you can give me!

Dump the listbox content in an Array and then sort the array. Then you can
dump the array back into the listbox.

For sorting an array, see:
http://word.mvps.org/faqs/macrosvba/SortArray.htm