Populate ComboBox from a column excluding duplicates?

[jfoerch]

Hi all,
I'm looking for some "hopefully" simple code to populate a ComboBox in a Userform from a column in a worksheet and exclude all duplicates. In this case...

Worksheet = Storage
Column = AD
Starting row in AD = 2
Number of used cells in AD will vary
trying to populate ComboBox2

This will happen when the userform is initialized. I tried using some other code I found posted elsewhere and was unable to get it to work. Appreciate the help!

[tigeravatar]

jfoerch,

Perhaps something like this?

Please Login or Register  to view this content.

[jfoerch]

That worked, but can it be done without sorting the column? The code that I found elsewhere but can't get to work is...

Please Login or Register  to view this content.

But, I don't know enough about the language to adapt this to my application. I don't know what the [A1],.[A65536] means and how to make that apply to just AD2 through the used portion of the column. And, I'm not sure if NoDupes is an actual command or a variable that I need to define first.

[tigeravatar]

Yeah, you don't have to sort it. I just put that in thinking it would be nice to have a sorted list. You can just delete that line if you want.

[jfoerch]

Perfect. Thanks!