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
| Option Explicit
'à ne pas oublier, ci-dessous
Option Compare Text 'mettre en haut du module, après "option explicit"
Private Sub UserForm_Initialize()
Dim i As Integer
With ComboBox1
For i = 1 To 6
.AddItem Range("B" & i)
.List(.ListCount - 1, 1) = Range("C" & i)
.List(.ListCount - 1, 2) = Range("D" & i)
Next i
.SetFocus
End With
End Sub
'_____________________________________________________________
Private Sub ComboBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Dim trouve As String, i As Integer
trouve = ComboBox1
With ComboBox1
.Clear
For i = 1 To 6
If Range("b" & i) Like trouve & "*" Then
.AddItem Range("B" & i)
.List(.ListCount - 1, 1) = Range("C" & i)
.List(.ListCount - 1, 2) = Range("D" & i)
End If
Next i
.listindex = 0
End With
End Sub |
Partager