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

preview_player
Показать описание
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
Рекомендации по теме