You can take John Walkenbach's code -- that makes it a really short way to do
it.

http://j-walk.com/ss/excel/tips/tip47.htm

Stephan Bielicke wrote:

Hello,

how can I get the entries of some column from a worksheet into a Listbox
that is part of an UserForm.
The column contains repeating entries, but the Listbox should show each
different entry only once.
Is there a short way to do this?
And another problem with this: If there is a filter on the worksheet, how
can I decide to use all entries or only those, shown by the filter?

Thanks

Stephan

--

Dave Peterson