Populate an array from Listbox items

[hemantparmar]

Typically I use a variant array to populate a listbox. (i.e. Me.listbox1.list = myArray)

Now I need to do reverse - fill an array using the multi-column listbox values

I tried the reverse statement: myArray = me.listbox1.list

But the array stores only the first ListColumn of the listbox. Any idea how to get this done?

Basically the objective is to:
1. store a listbox1 (as original array),
2. then let the user add or remove listrows
3. store the updated listbox1 in new array, and
4. re-produce the original array and new array in two new listboxes on another page of the multi-page userform for comparison purpose.

[AlphaFrog]

Please Login or Register  to view this content.

That should store a 2-D array in myArray.

If you see only one dimension in the Locals window, click the + button on one element in the array and you will see the second dimension.

[hemantparmar]

Thanks for waking me up. I had forgotten to change the ColumnCount from 1 to 6. I guess it was a hectic day for me yday and I needed some sleep.