ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multi Column Listbox Help (https://www.excelbanter.com/excel-programming/379829-re-multi-column-listbox-help.html)

Ken

Multi Column Listbox Help
 
This may help, it has helped me on several occasions.

http://www.dailydoseofexcel.com/arch...stboxcombobox/


Good luck.

Ken
Norfolk, Va




jayklmno wrote:
I have a listbox or 4 columns. I am populating it from certain elements from
a UDT. In trying to fill the list, I am clueless how to gte it to fill the
columns of data and not just put the 4 array elements into the first column...

Here is my code...

With lbProjects
.ColumnCount = 4
.ColumnWidths = "100;50;47;47"
.Clear
For x = 1 To UBound(temp)
.AddItem temp(x, 11) & " / " & temp(x, 10) & " / " & temp(x, 3) & "
/ " & temp(x, 9)
Next x
End With

How do I get the .additem line to put each of the 4 array elements in a
different column?




All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com