Need the Userform Combobox to display value from list only once

Good morning,

My current code is:

Please Login or Register  to view this content.

The lists I have have repeat values and I need the combobox to display these only once.

Thanks!

M

Wow, thanks John for your help! This almost works. The ShiftLevel combo box is displaying the list of supervisors instead of shiftlevel, but it is displaying the minimized list without all the duplicates. The supervisor combo box on the other hand is displaying all of the shiftlevels, including all the duplicates. I was looking into using CreateObject("scripting.dictionary") but haven't been able to get it successfully working.

Thanks!

M

I keep getting subscript out of range error, not sure what is causing it:

Please Login or Register  to view this content.

Alright, found this version but I end up with with the same list in both combo boxes

Please Login or Register  to view this content.

Couple typos, seems to be working!