Excel VBA UserForm ListBox Populate from an Array with Transposing it

preview_player
Показать описание
Excel VBA UserForm ListBox Learn how to populate from an array with transposing it.

The source code used in this video:

Private Sub UserForm_Initialize()
Dim aDays(2, 2)
aDays(0, 0) = "16/01/2015"
aDays(1, 0) = "17/01/2015"
aDays(2, 0) = "18/01/2015"

aDays(0, 1) = "Friday"
aDays(1, 1) = "Saturday"
aDays(2, 1) = "Sunday"

aDays(0, 2) = "weekday"
aDays(1, 2) = "weekend"
aDays(2, 2) = "weekend"

lbDays.Column = aDays

End Sub
Рекомендации по теме