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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/