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?