View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default 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