Solved: ListBox Columnwith

[jammer6_9]

I have created a ListBox where it has 10 columns. On the ListBox properties I can only adjust the first ColumnWith. How can I format the other column to my desired size...

[Charlize]

in centimeter :With ListBox1
.ColumnCount = 3 'no of columns (0,1,2)
.ColumnWidths = "3 cm;3 cm;3 cm" 'widths of columns
.ControlTipText = "Possible matches ..." 'tiptext
.ListStyle = fmListStylePlain
.SpecialEffect = fmSpecialEffectFlat
End WithCould be that you need to change ; to ,

Charlize

[jammer6_9]

That was correct charlize thanks. I have change "cm" to "pt" whick works.

With ListBox1
.ColumnCount = 3 'no of columns (0,1,2)
.ColumnWidths = "200 pt;200 pt;200 pt" 'widths of columns
.ControlTipText = "Possible matches ..." 'tiptext
.ListStyle = fmListStylePlain
.SpecialEffect = fmSpecialEffectFlat
End With



in centimeter :With ListBox1
.ColumnCount = 3 'no of columns (0,1,2)
.ColumnWidths = "3 cm;3 cm;3 cm" 'widths of columns
.ControlTipText = "Possible matches ..." 'tiptext
.ListStyle = fmListStylePlain
.SpecialEffect = fmSpecialEffectFlat
End WithCould be that you need to change ; to ,

Charlize