Sort Listbox Items
 

Anybody know an easy way to sort listbox items in
alphabetical order?

Sort Listbox Items
 

Sort before you add them to the listbox.

Jim Cone
San Francisco, CA

"Stratuser" wrote in message
...
Anybody know an easy way to sort listbox items in
alphabetical order?

Sort Listbox Items
 

Take a look at John Walkenbach's site:
http://j-walk.com/ss/excel/tips/tip47.htm

His example is actually filling a listbox with unique items, but he includes a
sort routine.

(or if the listbox is filled from a range, just sort the range first???)

Stratuser wrote:

Anybody know an easy way to sort listbox items in
alphabetical order?

--

Dave Peterson