1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
Sub UserForm_Initialize()
Dim MyArray(5, 5), MyArray2(5, 5)
For i = 0 To 5
MyArray(i, 0) = i
Next i
'Chargez les colonnes 2 et 3 de MyArray
MyArray(2, 0) = "Zéro"
MyArray(2, 1) = "Un"
MyArray(2, 2) = "Deux"
MyArray(2, 3) = "Trois"
MyArray(2, 4) = "Quatre"
MyArray(2, 5) = "Cinq"
MyArray2(1, 0) = "0"
MyArray2(1, 1) = "1"
MyArray2(1, 2) = "2"
MyArray2(1, 3) = "3"
MyArray2(1, 4) = "4"
MyArray2(1, 5) = "5"
'Charge les données dans les contrôles Liste2
Liste2.List = MyArray
ComboBox1.List() = MyArray |
Partager