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
| Private Sub ComboBox1_Change()If Me.ComboBox1.ListIndex > -1 Then MsgBox "Ligne: " & Me.ComboBox1.List(Me.ComboBox1.ListIndex, 0)
End Sub
Private Sub ComboBox2_Change()
If Me.ComboBox2.ListIndex > -1 Then MsgBox "Ligne: " & Me.ComboBox2.List(Me.ComboBox2.ListIndex, 0)
End Sub
Private Sub UserForm_Initialize()
With ThisWorkbook.Sheets("Feuil3").UsedRange
ReDim T(.Rows.count, 1)
For i = 2 To .Rows.count
T(i - 2, 0) = i: T(i - 2, 1) = .Cells(i, "A")
Next
End With
For i = 1 To 2
With Me.Controls("ComboBox" & i)
.BoundColumn = 2
.ColumnCount = 2
.ColumnWidths = "0;10"
.List = T
End With
Next
End Sub |
Partager