Thanks, interesting . . . have to think of what I could make of it.

Actually, what I'm looking to do is to edit my music file tags in excel by
mimicking the iTunes interface with the three "browser" list boxes (Genre,
Artist, Album) above, and the full columns and rows below. If you make no
choices (the default at the top of each list box is All), every song in the
library is listed in the rows and columns below.

As you move from left to right in the "browser" list boxes, each selection
you make filters the choices available in the next list box. For example,
choosing Rock under Genre filters out Jazz, Classical, etc., Artists, leaving
only Rock Artists and Rock Albums. (It also shows only Rock songs in the rows
and columns below.) Clicking a Rock Artist's name in the second list box
shows only his albums in the Albums list box, and his songs in the rows
below. Finally, clicking a specific album in the Album list box displays only
that album's songs in the bottom rows and columns.

I'm actually looking to hire someone to do this . . . if you are interested,
or can you recommend someone?

Thanks,

Dave

"Tom Ogilvy" wrote:

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