Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AddItem with multi-column listBox | Excel Programming | |||
Dynamic Multi Column ListBox | Excel Programming | |||
Multi-Column Listbox properties | Excel Programming | |||
populating a multi-column Listbox | Excel Programming | |||
populating a multi-column Listbox | Excel Programming |