filmov
tv
Excel VBA UserForm ListBox with Multiple Columns Populate (Column Property)

Показать описание
Excel VBA UserForm Learn how to populate ListBox with multiple columns (Column Property)
The source code used in this video:
Private Sub UserForm_Initialize()
With lbDays
.ColumnCount = 2
.AddItem "12/01/2015"
.List(0, 1) = "Monday"
.AddItem "13/01/2015"
.List(1, 1) = "Tuesday"
.AddItem "14/01/2015"
.List(2, 1) = "Wednesday"
End With
End Sub
The source code used in this video:
Private Sub UserForm_Initialize()
With lbDays
.ColumnCount = 2
.AddItem "12/01/2015"
.List(0, 1) = "Monday"
.AddItem "13/01/2015"
.List(1, 1) = "Tuesday"
.AddItem "14/01/2015"
.List(2, 1) = "Wednesday"
End With
End Sub