Hi,

I would like to sort a combox List by ascending order.
Currently, my macro does the following fine, need
additional code to sort the data, many thks

Private Sub ComboBox1_DropButtonClick()
Dim sh As Worksheet

ComboBox1.Clear
For Each sh In ActiveWorkbook.Worksheets
ComboBox1.AddItem sh.Name

Next
End Sub