populate listbox with array

[nigelog]

Hi
I have a created array of 8 items passed from a userform to another, I have tried 1 dimension array (1 to 8) and two dimension array (1 to 8,1 to 1) - (by transposing 1D array) but I can only get it to display as a vertical entry in the listbox rather than horizontally. I have tried many methods and variations of methods but no go...please someone put me out of this misery

Please Login or Register  to view this content.

[rorya]

Instead of transposing the array, just assign it to the Column property of the listbox.

[nigelog]

Please Login or Register  to view this content.

Thankyou so much