filmov
tv
Excel VBA UserForm Listbox Option Base Statement

Показать описание
Excel VBA UserForm Listbox Learn about Option Base Statement
The source code used in this video:
Option Base 1
Private Sub UserForm_Initialize()
Dim aDays(3, 3)
aDays(1, 1) = "16/01/2015"
aDays(2, 1) = "17/01/2015"
aDays(3, 1) = "18/01/2015"
aDays(1, 2) = "Friday"
aDays(2, 2) = "Saturday"
aDays(3, 2) = "Sunday"
aDays(1, 3) = "weekday"
aDays(2, 3) = "weekend"
aDays(3, 3) = "weekend"
lbDays.List = aDays
End Sub
The source code used in this video:
Option Base 1
Private Sub UserForm_Initialize()
Dim aDays(3, 3)
aDays(1, 1) = "16/01/2015"
aDays(2, 1) = "17/01/2015"
aDays(3, 1) = "18/01/2015"
aDays(1, 2) = "Friday"
aDays(2, 2) = "Saturday"
aDays(3, 2) = "Sunday"
aDays(1, 3) = "weekday"
aDays(2, 3) = "weekend"
aDays(3, 3) = "weekend"
lbDays.List = aDays
End Sub