Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AddItem with multi-column listBox David Excel Programming 4 October 26th 05 05:51 PM
Dynamic Multi Column ListBox Ronbo Excel Programming 3 January 11th 05 07:59 PM
Multi-Column Listbox properties Otto Moehrbach[_6_] Excel Programming 1 December 5th 04 10:35 PM
populating a multi-column Listbox Tom Ogilvy Excel Programming 3 April 26th 04 08:26 PM
populating a multi-column Listbox Harald Staff Excel Programming 1 April 26th 04 08:26 PM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"