Dynamic Named Ranges Not Recalculating

[Ozan Ertem]

Hi,
I have run into a peculiar problem and I am quite stuck. I have a problem with a section of code I am using in a larger project. The relevant part of the project is attached.
The Private Sub Cbo_Product_Tier2_DropButtonClick() in Sheet "Ürün tanımlama" extracts entries from the relevant column in the products sheet, moves them over the temp_Sheet1 where it removes dupplicates. And then assigns the DNR "Product_Tier2" to the list for combobox Cbo_Product_Tier2.
i.e. populates a dropbox based on the values of another drop box.

The DNR Product_Tier2 is:

=OFFSET(Temp_Sheet1!$B$1;0;0;COUNTA(Temp_Sheet1!$B:$B);1)

This works fine.

However, although the combobox displays the list correctly and without duplicates, when I select a value from the correctly populated list, the combobox selects the value based on the list before the duplicates were removed.
To give an example: Below are the two sets of data that are generated by Private Sub Cbo_Product_Tier2_DropButtonClick() when "KURU YEMİŞ" is selected for Tier1 in the first combobox (with and without removing duplicates). In this case, when I select Kokteyl from the drop down, the value of the combobox becomes Fındık. When I select Fındık, it becomes Kestane. Badem seems to work fine, because the assignment is the same and for some reason Kuru A2 also works fine apperantly because there is no corresponding assignment.

This is driving me insane. I tried putting lines to recalculate sheets and ranges with no result. Any help to explain why this is occurring and how I may resolve it or go around it is very much appreciated!

w dupl. - wo. Dupl
Antep Fıstığı - Antep Fıstığı
Badem - Badem
Ceviz - Ceviz
Ceviz - Kokteyl
Kokteyl - Fındık
Fındık - Kestane
Fındık - Kuru Armut
Kokteyl - Kuru Dut
Kokteyl - Kuru Elma
Kestane - Kuru Erik
Kuru Armut - Kuru İncir
Kuru Dut - Kuru A1
Kuru Elma - Kuru Kayısı
Kuru Erik - Kuru A2
Kuru İncir - Kuru Üzüm
Kuru A1 - Kuru A3
Kuru Kayısı - Kuru A4
Kuru A2 -
Kuru Üzüm -
Kuru A3 -
Kuru A4 -