Sorting A Named Range

[BrianExcel]

I have three named ranges, each of which populates the same combo box depending which of three combo boxes are chosen.

What I need to happen is for the range within the combo box to sort Ascending, but not necessarily the source data set. If the source data changes fine, but what's important is that the combo box sort and display correctly.

Ideas?

 

[Ralajer]

The following will sort the range on the sheet.

    Dim nameRng As Range
    Set nameRng = Range("NAMEDRANGE")
    nameRng.Sort Key1:=nameRng.Cells(1, 1), Order1:=xlAscending

Let me know if that works.