Alright, this seems silly, and like being between a rock and a hard place.
It is GREAT that I can take a multi-dimentional array and simply assign it to a multi-column listbox (me.Lstbox = myarray). It fills the list box so fast the user doesn't see the list being filled.
However, I can only redim and array by the LAST element, which means changing the configuration of the array, which means I can't simply assign it to the multi-column list box!
It seems there should be some easy way around this, though I've not found any without looping through the array and manually assigning the various elements in both dimentions. Easily enough done, but annoying.
Is there something I'm missing?
Many thanks,
Ken
It is GREAT that I can take a multi-dimentional array and simply assign it to a multi-column listbox (me.Lstbox = myarray). It fills the list box so fast the user doesn't see the list being filled.
However, I can only redim and array by the LAST element, which means changing the configuration of the array, which means I can't simply assign it to the multi-column list box!
It seems there should be some easy way around this, though I've not found any without looping through the array and manually assigning the various elements in both dimentions. Easily enough done, but annoying.
Is there something I'm missing?
Many thanks,
Ken