Sorting Items in a ComboBox (ActiveX Control) in Excel 2003
 

I am populating a ComboBox in an Excel Spreadsheet with alpha numeric
characters (ex; S10010, 12345, or G6544) and I haven't been able to figure
out how to sort all of its contents....the way i do it now is by transfering
all data in the combobox to cells in my Excel Spreadsheet then letting Excel
do the work of sorting... i would however like to bypass that extra step of
dumping data from Point A to Point B and then again to Point C (where all the
data is in a sorted manner). Anybody have any suggestions?? Thanks

Sorting Items in a ComboBox (ActiveX Control) in Excel 2003
 

this fills a listbox with a sorted list of unique items. You can adapt the
techniques here to do what you want.

http://www.j-walk.com/ss/excel/tips/tip47.htm

--
Regards,
Tom Ogilvy


"Kevin E." wrote:

I am populating a ComboBox in an Excel Spreadsheet with alpha numeric
characters (ex; S10010, 12345, or G6544) and I haven't been able to figure
out how to sort all of its contents....the way i do it now is by transfering
all data in the combobox to cells in my Excel Spreadsheet then letting Excel
do the work of sorting... i would however like to bypass that extra step of
dumping data from Point A to Point B and then again to Point C (where all the
data is in a sorted manner). Anybody have any suggestions?? Thanks