ExcelBanter - test vba in listbox (UF)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - test vba in listbox (UF) (https://www.excelbanter.com/excel-programming/301355-test-vba-listbox-uf.html)

Mark[_17_]

test vba in listbox (UF)

How in listbox (UF) setting column's width (i've 6 column
and i'd like each one in different width) and format
column ??

Regards
Mark

mangesh_yadav[_13_]

test vba in listbox (UF)

just set the columnwidths property as shown

With Me.lbItems
.ColumnCount = 3
.ColumnWidths = "100, 50, 200"

' add items

End With

or you can also do the same in the properties

- Manges

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 12:06 AM.