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

preview_player
Показать описание
Excel VBA UserForm Learn how to populate ListBox with multiple columns (List 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
Рекомендации по теме
Комментарии
Автор

hi, how can i choose 1 column's info ( like Date and DayName)

kamilakarsu.
welcome to shbcf.ru