filter from combo box? (not autofilter)

Here is what i'm trying to do:

I need a drop down list so my users can select and apply a filter. The "auto filter" method is a little clunky and allows sorting, which I dont want. So, i'm hoping that I can make a selection with a combo box, then automatically filter based on that selection. Is there a way to do this?

Hi,

Visit this place for a comprehensive tutorial on what you are trying to do:

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

Cheers

Derek