Private Sub UserForm_Initialize()
Dim i As Byte
For i = 1 To 10
ComboBox1.AddItem Range('a' & i)
Next i
For i = 0 To ComboBox1.ListCount
For j = i + 1 To ComboBox1.ListCount - 1
If ComboBox1.List(i) > ComboBox1.List(j) Then
Temp = ComboBox1.List(j)
ComboBox1.List(j) = ComboBox1.List(i)
ComboBox1.List(i) = Temp
End If
Next j
Next i
End Sub