sorting listbox

[Kars Lensen]

We can sorted a listbox by setting the property 'sorted' on true and the
list is sorted by the first letter(s) of the records in the listbox.
Is it also possible by starting at, say collumn 10 to sort ?
If yes, how ?

[gfrench]

The best way to do that is put all of the list items in an array, then move the items in the order you want to the listbox, this will allow you to sort it in any way you want.

Hope this helps,

[Kars Lensen]

Thanks for the reply, can you give me a small example, I am
not familiar with Array's....

[gfrench]

An array is basically a variable that can store loads of values:

You are used to putting Variable1 = "Hello"

An array you would put Variable1(0) = "Hello"
then you could continue Variable1(1) = "Hello2"
and on and on, you get the point.

To declare an array you should use the code below:

'You should change 20 to the maximum number of entries you
'want, and string to whatever data type you will be using.
Dim Variable1(20) as String


If you could mail me the code you already have it would help, please mail it to [email protected]

I will take it from there,