Sort combobox vba
Unfortunately, combobox in VBA does not come with a sort feature you can use. You need to sort the data list before adding them to the combobox. if the dropdown list has to sort differently at run time, you need to clear the combobox, resort the data list and re-add them back to the combobox.
Since the built-in data structure in VBA (array, collection) also do not have built-in sorting method, you need to write your own sorting code. Fortunately there are a lot code samples on the net for various sorting algorithms that you can directly use, or with minor modification.
