P
Pegawars
I have a unbound listbox and data is present, i want to sort it. How do
i do that???
i do that???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Graham Mandeno
Add an ORDER BY clause to the RowSource query of the listbox.
P
Pegawars
Graham said: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?
G
Guest
Try sorting the list before you loop through it and add the items....?
G
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".
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".