1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| Private Sub UserForm_Initialize()
Dim i As Single
Dim myArray(5, 2) As String
Me.ComboBox1.ColumnCount = 3
For i = 0 To 5
myArray(i, 0) = i
Next i
'Load columns 2 and three of MyArray
myArray(0, 1) = "Zero"
myArray(1, 1) = "One"
myArray(2, 1) = "Two"
myArray(3, 1) = "Three"
myArray(4, 1) = "Four"
myArray(5, 1) = "Five"
myArray(0, 2) = "Zero"
myArray(1, 2) = "Un ou Une"
myArray(2, 2) = "Deux"
myArray(3, 2) = "Trois"
myArray(4, 2) = "Quatre"
myArray(5, 2) = "Cinq"
'Load data into ListBox1 and ListBox2
Me.ComboBox1.List() = myArray
End Sub |
Partager