filmov
tv
Excel VBA UserForm ListBox Populate from an Array with Transposing it

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