Sorting Excel combo box list

[Ballistix]

I want an Excel VB combo box to display unique sorted entries (numbers
and text) in the drop-down list.

The unique entries bit is easy enough, but I can't figure out how to
have it sort the range (other than by putting the range on a hidden
worksheet and using a macro to sort it).

Ideas?

Justin

 

[Tom Ogilvy]

See John Walkenback's page. He uses a relatively slow bubble sort, but it
isn't bad for small lists:

http://j-walk.com/ss/excel/tips/tip47.htm
Filling a ListBox With Unique Items