Problems of list box property

[*¡¸ My-Ricky ¡¸*]

Dear all,

I have 4 columns in a list box, in the listbox property I can only set one column width. How can I
set, say, column 1 column width=50, column 2=30, column 3=40 and column=100?

Also, I have set headers=true in listbox property. However, it only shows a blank row in in first
row. How can I add the title to the headers of the list?

Thank you in advance!



--

 

[Jim Rech]

You can set the column widths in the Properties window or at run time like
this:

ListBox1.ColumnWidths = "25;50;10"

I believe you can only show headers if you populate the listbox from the
worksheet via the RowSource property. And do not include the header row in
the LinkSource range.

So with headers in A11 and data in A210 use this in Linksource: A210

--
Jim
| Dear all,
|
| I have 4 columns in a list box, in the listbox property I can only set one
column width. How can I
| set, say, column 1 column width=50, column 2=30, column 3=40 and
column=100?
|
| Also, I have set headers=true in listbox property. However, it only shows
a blank row in in first
| row. How can I add the title to the headers of the list?
|
| Thank you in advance!
|
|
|
| --
|
|
|

 

[*¡¸ My-Ricky ¡¸*]

Thank you very much for your precious solutions and quick response. It works! ^_^