Instead of combo boxes, you could use data validation, which would sort
with the data. There are instructions in Excel's Help, and he

http://www.contextures.com/xlDataVal01.html

Anne Jett wrote:
I am working on a rather large database that is used by several people within
the company...we have many product models to choose from, so I have inserted
the combo drop boxes but now I can no longer use the sort function. Any
ideas????


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html