Hello All

I have 3 activex combobox in a spreadsheet. One for Region, another for Country and a last one for City. The region depends on the selection in the list country, and the city depends on the selection in region.

I have 3 dependent named ranges that are populated by a macro in a different spreadsheet. Example:

DESCTY =OFFSET(DesReg_Start,(MATCH(FreightCalculator!$A$14,DesReg_Column,0)-1),1,COUNTIF(DesReg_Column,FreightCalculator!$A$14),1)

Then another macro populates the combo box like this:

ComboBox9.ListFillRange = "DESCTY"

It works, but for some reason, the list of restricted Cities is showing more than one time. For example, if the Region selected is US East Coast, then it should show
Baltimore
Boston
Buffalo
.
.

But instead, it is showing

Baltimore
Boston
Buffalo
.
.
Baltimore
Boston
Buffalo
.
.
Baltimore
Boston
Buffalo
.
.

The dependent named range works fine. It shows correctly, but for some reason when it is feed to the combo box it duplicates it several times

What could be causing this issue?