Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems of list box property
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! -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems of list box property
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 A1:D1 and data in A2:D10 use this in Linksource: A2:D10 -- Jim "*¡¸ My-Ricky ¡¸*" wrote in message ... | 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! | | | | -- | | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems of list box property
Thank you very much for your precious solutions and quick response. It works! ^_^
"Jim Rech" bl... 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 A1:D1 and data in A2:D10 use this in Linksource: A2:D10 -- Jim "*¡¸ My-Ricky ¡¸*" wrote in message ... | 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! | | | | -- | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
need VB list property for file contents | Excel Programming | |||
Problems sorting from VB when some rows include Borders property | Excel Programming | |||
Combobox List - Which Property | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming |