View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 207
Default 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?