title: Sort ActiveX Combobox list data
body: <p>I have an ActiveX combo box that sources its data from a list of suburbs, which occur in my spreadsheet in alphabetical order. The suburbs have a rank assigned to them, however it is important that the order in which they appear from my combo box is based on rank. They need to remain in the spreadsheet in alphabetical order though. </p>
  
  <p>Is there a way of doing this in Excel, with or without VBA? </p>