How do I insert combo drop box and still be able to sort?

[Anne Jett]

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]

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

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