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