Loading...
「ツール」は右上に移動しました。
利用したサーバー: wtserver1
6いいね 1,331 views回再生

Excel VBA UserForm Combobox Populate from an Array with Transposing it

Excel VBA UserForm Combobox 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"

cbDays.Column = aDays


End Sub

コメント