Sorting a Listbox

[Pegawars]

I have a unbound listbox and data is present, i want to sort it. How do
i do that???

 

[Graham Mandeno]

Add an ORDER BY clause to the RowSource query of the listbox.

 

[Pegawars]

Add an ORDER BY clause to the RowSource query of the listbox.

That's the problem,i filled the list with listbox1.additem Item:=Blabla.

How can i order after that?

 

[Frank Marckus]

Try sorting the list before you loop through it and add the items....?

 

[Graham Mandeno]

The AddItem method simply appends (or inserts) an item in a string delimited
by semicolons. So if you AddItem "Tom", then "Dick", then "Harry", your
RowSource string will be "Tom;Dick;Harry".

You can use the Split function to morph this string into an array of three
strings, then use your favourite sort algorithm to sort the array, then
finally use the Join function to recreate a delimited string:
"Dick;Harry;Tom".