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

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

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

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

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