View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default ListBox Column Widths

You can adjust the ColumnWidths right in the Properties box if the widths
are fixed, or with code at runtime:

ListBox1.ColumnWidths = "30;40;50"

--
Jim
"sgl" wrote in message
...
|I have a 3 column worksheet (chart of accounts - Code, Detail, Group). Each
| column is of a different width. I can load these 3 columns onto a ListBox
but
| some of the text is not legible as all columns are of the same size in the
| ListBox. Need some code to adjust column widths in the LIstBox so that all
of
| the text in each column is legible.
|
| Many thanks/sgl