Distribute array over multiple columns in listbox
Hello,
I want to populate Listbox1 with a filtered array (MyArr) from Sheet1. Instead of distributing MyArr over 7 columns (as I want), the whole array is put in the first column.
How do I get MyArr to distribute itself in 7 columns?
Please Login or Register to view this content.
Set your seven column widths to suit your needs. eg.
Please Login or Register to view this content.
Thank you for your quick response.
Unfortunately that doesn't work. The whole array remains listed down in one column. Any thoughts?
You're only populating a one dimensional array. You need a 2D array. Since you can only alter the last dimension when using Redim Preserve, make the array 7 rows and multiple columns, then assign it to the Column property of the listbox, rather than List, in order to transpose it back.
Rory
Try this:
Please Login or Register to view this content.
Works!
I was still trying the solution provided by Rorya, but you beat me to it Akuini! Thank you 🙏!
You're welcome, glad to help, & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks