ExcelBanter - Excel; vba; listbox how to reorganize list in alfabetical order

John Walkenbach has a routine that fills a listbox with unique items. He has
code in his routine that sorts it, too.
http://j-walk.com/ss/excel/tips/tip47.htm

Konrad wrote:

Tks for yr help

to tell you the true the way you sugested is the easiest
but my idea was to make it faster
what I'm thinking about now is to create an array or two
of them and then use them to do that

Tks

Konrad

-----Original Message-----
If th elistbox range comes from a table, then sort the
table and refresh the listbox
if the listbox is populated from code, then drop the
values into a new table, sort it on the sheet & reload
the listbox.
I would not try to sort the list in memory - excel's soth
method works very fast and is very good - do not re-
invent the wheel ;)

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
under the excel (or any of MS office appl) I have a
listbox
the list is already fill in And I want to change
positions
of the items in order to have them in alfabetical order
list consist of words, the len can be diffrent,upper or
lower case does not metter.

Tks
konrad
.

.

--

Dave Peterson