John Walkenbach shows how to do it

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

--
Regards,
Tom Ogilvy




"daveroblit" wrote in message
...
Thanks. I've been reading up, and I think what I really want is a list box
that functions like an autofilter pull-down. It just displays 10 lines or
so
at a time and has a scroll bar. Anyone know how to assign autofilter
behavior
to a list box?

"Tom Ogilvy" wrote:

There are no configurable aspects to an autofilter pulldown.

--
Regards,
Tom Ogilvy

"daveroblit" wrote in message
...
Sorry, I think I should have posted this here to start.

Any way to get an Autofilter pulldown to display as a scrolling list?

Thanks,

Dave