Use the advanced filter to build a unique list in another location and use
that.

create a collection and populate it from your entries, then put those in the
listbox. See John Walkenbach's sample code:

http://j-walk.com/ss/excel/tips/tip47.htm
Filling a ListBox With Unique Items

--
Regards,
Tom Ogilvy

"Bryan" wrote in message
...
How can I populate a combo box with a query that filters the distinct
items
from a column in a different worksheet?