Dependant Activex ComboBox duplicating the items

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?

Hello

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

is not VBA. It is the way I defined the named range in Excel so it is a dependent drop down list

I am using VBA to assign the named range to the activex control

Hello
I don't think the problem is the named range. When I select a country from the drop down "Country", and I go to Name Manage in Excel and select DESCTY it highlights the correct range in Excel...

I am really at lost here..