Private Sub ComboBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Dim MyVar As Long, cmb, t()
If Me.ComboBox1 = "" Then Exit Sub
Set cmb = ComboBox1
If IsNumeric(Me.ComboBox1) = True Then
MyVar = Application.IfError(Application.Match(Val(ComboBox1.Value), ComboBox1.List, 0), -1)
If MyVar > -1 Then ComboBox1.ListIndex = MyVar - 1: ComboBox1.DropDown
End If
End Sub
Private Sub UserForm_Initialize()
With Sheets("Feuil1")
Me.ComboBox1.List = .Range("A2:A" & .Range("A65536").End(xlUp).Row).Value
End With
End Sub