Populating a combobox

[Guest]

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

 

[rzitowsk]

Are we to assume that the combo box list must be updated dynamically?
Otherwise, it would be easier to make a fixed combo box list and tie
it to the combo box.

 

[Guest]

Thanks for getting back to me. Sorry for the delay in response but I had to
go out of town yesterday.

To answer the question, yes. The page the list draws from will change every
day. Yes, if it were static I would definitely use a combobox.

Thanks for the help.

Scott