Populating a Listbox from array

[Rocky0201]

Hi,

I have a listbox which I wish to have more than 10 columns (11 to be exact). I am trying to build an array with the items for each column but I am having problems understanding how to build the array, how to redim, etc. The array will have to have variable number of rows of 11 columns for the listbox.

Once I have the array built, I would set the listbox's column count to 11, set the column widths and then do a listbox6.list = varray

Please help...

Thanks,

 

[Rocky0201]

Thanks so very much Norie. Your patients and help have been outstanding!!!

I thought about using labels for the header definitions. At the time, I didn't think I would have the real estate on the usferform. Obviously that is not an issue.

Now that I know how to manipulate arrays for this particular function, I can now go back and clean up my code and try to be more efficent.

Thanks again....