Classeur avec liste déroulante

Sub Remplissage()
Dim i As Integer
    With UsfOnglet.CboOnglets
        .Clear
        .Value = ActiveSheet.Name
        For i = 1 To Worksheets.Count
            If Worksheets(i).Name <> "sommaire" Then
                .AddItem Sheets(i).Range("A1").Value
            End If
        Next i
    End With
End Sub

Private Sub CboOnglets_Change()
For Each feuille In Sheets
    If feuille.Range("A1").Value = CboOnglets.Value Then
        feuille.Select
        Exit For
    End If
Next
End Sub

Private Sub UserForm_Initialize()
  Dim temp()
  For i = 2 To Sheets.Count
    Me.ComboBox1.AddItem
    Me.ComboBox1.List(i - 2, 0) = Sheets(i).[A1]
    Me.ComboBox1.List(i - 2, 1) = Sheets(i).Name
  Next i
  temp = Me.ComboBox1.List
  Call tri(temp(), LBound(temp, 1), UBound(temp, 1), 2, 0)
  Me.ComboBox1.List = temp
End Sub

Private Sub ComboBox1_Change()
  m = Me.ComboBox1.Column(1)
  Sheets(m).Select
End Sub

Sub tri(a(), gauc, droi, NbCol, colTri) ' Quick sort
   ref = a((gauc + droi) \ 2, colTri)
   g = gauc: d = droi
   Do
     Do While a(g, colTri) < ref: g = g + 1: Loop
     Do While ref < a(d, colTri): d = d - 1: Loop
       If g <= d Then
          For c = 0 To NbCol - 1
             temp = a(g, c): a(g, c) = a(d, c): a(d, c) = temp
          Next
          g = g + 1: d = d - 1
       End If
   Loop While g <= d
   If g < droi Then Call tri(a, g, droi, NbCol, colTri)
   If gauc < d Then Call tri(a, gauc, d, NbCol, colTri)
End Sub