Sorting Excel combo box list
 

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/

Sorting Excel combo box list
 

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

--
Regards,
Tom Ogilvy


Ballistix wrote in message
...
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/