Martin has given good advice in emphasizing that items don't have to be
isnerted at the end of the list. Here is some addtional information:

This article by John Walkenbach shows how to fill a listbox (or combobox)
with a unique list of sorted items. You can use the whole approach or
extract what you need and adapt it to your situation.

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

--
Regards,
Tom Ogilvy


"Corey" wrote: