Hi everyone,

First, I must say that this is a great forum, you guy's have helped me a
number of times and I really appreciate it.

With that said, I have yet another question. Is there a way to populate a
combobox (active X type) with unique names from a large list of data?. Here
is a short example, but picture hundereds of rows of data and multiple colums.

For example, if you have a column with 6 rows of data and a name appears
multiple times, how do you populate the combobox, with vba code, with each
unique name without duplicates? Result should show a combobox with 3 names.

Column A
Scott
Scott
Bob
John
John
John

Thanks for the help,

Scott J