Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

divider lines to multi column list box

Status
Not open for further replies.

waltron

Technical User
Jul 30, 2009
2
AU
i have a multi column listbox with 3 columns, i would like to add verticle divider lines how is this done.

this is my current code:

Sub LoadlistBox1()


Dim lbtarget As MSForms.ListBox
Dim rngsource As Range

Set rngsource = Worksheets("Sheet5").Range("A3:D40")

Set lbtarget = Me.ListBox1

With lbtarget
.ColumnCount = 4
.ColumnWidths = "60;192;60;60"
.List = rngsource.Cells.Value
End With

End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top