Multi Column UserForm ListBox

M

Mik

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
 
J

Jake Marx

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top