Access AutoFilter list for use with input box?
When the AutoFilter is active, a click on the arrow will show a list of
items. This list is also available as a drop-down in the Custom Filter dialogue box. Is there a way to access this list to use as a drop-down list for an Input Box? Ed |
Access AutoFilter list for use with input box?
Nope. You have to get the list yourself.
John Walkenbach has a technique to get unique values in his Listbox example: http://j-walk.com/ss/excel/tips/tip47.htm Another option may be to apply Data|filter|Advanced filter (uniques only). Then loop through those visible cells (or paste it into a work area and grab them from there). Ed wrote: When the AutoFilter is active, a click on the arrow will show a list of items. This list is also available as a drop-down in the Custom Filter dialogue box. Is there a way to access this list to use as a drop-down list for an Input Box? Ed -- Dave Peterson |
Access AutoFilter list for use with input box?
or select copy to another location and "grab them from there"
-- Regards, Tom Ogilvy Dave Peterson wrote in message ... Nope. You have to get the list yourself. John Walkenbach has a technique to get unique values in his Listbox example: http://j-walk.com/ss/excel/tips/tip47.htm Another option may be to apply Data|filter|Advanced filter (uniques only). Then loop through those visible cells (or paste it into a work area and grab them from there). Ed wrote: When the AutoFilter is active, a click on the arrow will show a list of items. This list is also available as a drop-down in the Custom Filter dialogue box. Is there a way to access this list to use as a drop-down list for an Input Box? Ed -- Dave Peterson |
Access AutoFilter list for use with input box?
oops.
(that's really what I meant. Really... <vbg) Tom Ogilvy wrote: or select copy to another location and "grab them from there" -- Regards, Tom Ogilvy Dave Peterson wrote in message ... Nope. You have to get the list yourself. John Walkenbach has a technique to get unique values in his Listbox example: http://j-walk.com/ss/excel/tips/tip47.htm Another option may be to apply Data|filter|Advanced filter (uniques only). Then loop through those visible cells (or paste it into a work area and grab them from there). Ed wrote: When the AutoFilter is active, a click on the arrow will show a list of items. This list is also available as a drop-down in the Custom Filter dialogue box. Is there a way to access this list to use as a drop-down list for an Input Box? Ed -- Dave Peterson -- Dave Peterson |
Access AutoFilter list for use with input box?
Thanks for the help, Dave and Tom.
Ed "Dave Peterson" wrote in message ... oops. (that's really what I meant. Really... <vbg) Tom Ogilvy wrote: or select copy to another location and "grab them from there" -- Regards, Tom Ogilvy Dave Peterson wrote in message ... Nope. You have to get the list yourself. John Walkenbach has a technique to get unique values in his Listbox example: http://j-walk.com/ss/excel/tips/tip47.htm Another option may be to apply Data|filter|Advanced filter (uniques only). Then loop through those visible cells (or paste it into a work area and grab them from there). Ed wrote: When the AutoFilter is active, a click on the arrow will show a list of items. This list is also available as a drop-down in the Custom Filter dialogue box. Is there a way to access this list to use as a drop-down list for an Input Box? Ed -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 09:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com