Order in a array / ListBox
Hello
I have a listbox which will be loaded from an array named MyArray(100,5)
My listbox has so 5 columns ....
I desire to order my listbox, after a record insertion, by col 1 and col 0
again.
My idea is to sort my array, before to load it again in the ListBox ...
But how can I do it ?
For the moment I write my Array in a temp sheet range, order there, copy
back to my Array and then reload my ListBox .... pfff :-(
Any other idea ?
Thanks and best regards
Dan
|