Multi Column UserForm ListBox
 

I have a UserForm listbox where i want to display the contents of a
worksheet range in 3 listbox columns.

example:
Cell value of "A1:A10" in Column 1
Cell value of "B1:B10" in Column 2
Cell value of "C1:C10" in Column 3

Would it be easier with an ARRAY of text in the Userform code or
Additem?
I am open to suggestions.

Please spell out the code, as I am still learning and new to Userforms
/ ListBox.

Thanks

Multi Column UserForm ListBox
 

Hi Mik,

You actually don't need any code for this. You can set the RowSource
property of the ListBox to Sheet1!A1:C10, then set the ColumnCount property
to 3. Now, when the form is loaded, it will display 3 columns of data from
Sheet1 cells A1:C10.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]


Mik wrote:
I have a UserForm listbox where i want to display the contents of a
worksheet range in 3 listbox columns.

example:
Cell value of "A1:A10" in Column 1
Cell value of "B1:B10" in Column 2
Cell value of "C1:C10" in Column 3

Would it be easier with an ARRAY of text in the Userform code or
Additem?
I am open to suggestions.

Please spell out the code, as I am still learning and new to Userforms
/ ListBox.