Column widths in ListBox

[russkie]

Hello,

Hey um, this sounds like a simple thing to me, but i cant find out how to do this in help or searching around other places... How do you set the distinct column widths in a listbox? column1=width200, column2=width300... like that? Say listbox is call "MojoBox"

thanks for any help.:think:

[johnske]

With MojoBox
.ColumnCount = 2
.ColumnWidths = "200;300" '< separate with semi-colons
End With

[BlueCactus]

MojoBox.ColumnWidths = "200; 300"

You can also do this in the UserForm editor. You need to include the semicolons. Note that you do not need to specify the widths of all the columns (I often leave the last column up to VBA).

[russkie]

Perfect, thank mucho mucho