Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Pulldown
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Pulldown
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Pulldown
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Pulldown
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Pulldown
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Pulldown
Hi,
I put up some screenshots and explanations: http://dmp3digital.com/excel.htm Dave "Tom Ogilvy" wrote: But this is already provided by the the autofilter. the only difference is you have to click the dropdown to see the choices. At the same time, you can look at the database/rows themselves for the complete picture - once you get genre, artist and album, only the songs should be displayed below. I haven't seen iTunes, but if you can't see the genre, artist and album in the list below, you could reproduce that by hiding those columns and interacting with listboxes as you describe (but the listboxes would be setting conditions in the hidden autofilter dropdowns or using the advanced filter criteria). If I did it, I would just be applying an autofilter and using John's code to populate the Listboxes. If you want to send me your file and a description of what you want it to look like/operate, I will take a look. -- Regards, Tom Ogilvy "daveroblit" wrote in message ... 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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Pulldown
Similar to what I envisioned at least in concept.
If there are 55 artists, then 33 Albums seems suspect. That would indicate that all the artists are not included in the database? -- Regards, Tom Ogilvy "daveroblit" wrote in message ... Hi, I put up some screenshots and explanations: http://dmp3digital.com/excel.htm Dave "Tom Ogilvy" wrote: But this is already provided by the the autofilter. the only difference is you have to click the dropdown to see the choices. At the same time, you can look at the database/rows themselves for the complete picture - once you get genre, artist and album, only the songs should be displayed below. I haven't seen iTunes, but if you can't see the genre, artist and album in the list below, you could reproduce that by hiding those columns and interacting with listboxes as you describe (but the listboxes would be setting conditions in the hidden autofilter dropdowns or using the advanced filter criteria). If I did it, I would just be applying an autofilter and using John's code to populate the Listboxes. If you want to send me your file and a description of what you want it to look like/operate, I will take a look. -- Regards, Tom Ogilvy "daveroblit" wrote in message ... 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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Pulldown
Some of the albums are compilations, with more than one artist. So the number
of artists is larger than the number of albums. "Tom Ogilvy" wrote: Similar to what I envisioned at least in concept. If there are 55 artists, then 33 Albums seems suspect. That would indicate that all the artists are not included in the database? -- Regards, Tom Ogilvy "daveroblit" wrote in message ... Hi, I put up some screenshots and explanations: http://dmp3digital.com/excel.htm Dave "Tom Ogilvy" wrote: But this is already provided by the the autofilter. the only difference is you have to click the dropdown to see the choices. At the same time, you can look at the database/rows themselves for the complete picture - once you get genre, artist and album, only the songs should be displayed below. I haven't seen iTunes, but if you can't see the genre, artist and album in the list below, you could reproduce that by hiding those columns and interacting with listboxes as you describe (but the listboxes would be setting conditions in the hidden autofilter dropdowns or using the advanced filter criteria). If I did it, I would just be applying an autofilter and using John's code to populate the Listboxes. If you want to send me your file and a description of what you want it to look like/operate, I will take a look. -- Regards, Tom Ogilvy "daveroblit" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulldown that searches? | Excel Discussion (Misc queries) | |||
Using value from pulldown box in macro | Excel Programming | |||
pulldown boxes | Excel Programming | |||
pulldown boxes | Excel Programming | |||
pulldown boxes | Excel Programming |