Module Subs executing Private Subs without prompt by code - Totally Lost

Ozan

When I run the code it errors here saying it can't find the 'Cbo_Product_Tier1'.

Please Login or Register  to view this content.

Is there anything else we need to do to get the code to illustrate the problem?

Is there a specific sheet that needs to be active for the code to work?

I don't see that, but get an error on this line:

Please Login or Register  to view this content.

What sheet is supposed to be active?

EDIT: Yeah, what Norie said ...

Is it the sheet Ürün Tanımlama that should be active?

I just found the sub you say is being called - it's empty.

Managed to get a bit further but now I get a 'Subscript out of range' error here.

Please Login or Register  to view this content.

If I change Sheets("Ürün Tanımlama") to the codename Sheet11 the code works but no Product_ID is found.

Hi,
Yes Sheet (Ürün Tanımlama) should be active.
Perhaps you are getting the subscript out of range error due to the fact there are "ı"s and "ü"s in the sheet name and the code? I don't get that error. The code I sent you actually works but makes this crazy detour to private function.

Changing the sheet name would probably mess up the whole code though.
I would love to go over it and share my screen via skype if you feel up to it.

Ozan

Edit. Cbo_Product_Tier1 is the topmost combo box on the sheet Ürün tanımlama. The ones below are Tier2 and Tier 3 in order.

Ozan

The 'crazy detour' is to a sub that does nothing.

It could be happening because something in the code for Product_Edit is changing the source of the combobox.

As for the sheet name, I'm not sure what's happening but in the code you have the name with a y in it where there should be an i.

I didn't change the sheet name, I just changed how the code so it referred to it using the code name.

How is the combobox populated?

If it's from a range does Product_Edit change the range in anyway.

Hi,
The combobox Cbo_Product_Tier3 is populated from the dynamic named range Product_Tier3 via the Cbo_Product_Tier3_DropButtonClick () private sub in sheet(ürün tanımlama).

The code in sub Product_Edit does not have any reference to that range which resides in Sheet(Temp_Sheet1). The last line executed before the jump to the empty priva sub is:

Please Login or Register  to view this content.

Have you been able to recreate the detour I mentioned?

EDIT: Would it help if I created an English character version of the file?

EDIT2: I will click one thousand of your stars if we can figure this out :D

Yes, but not properly - I had to skip parts of the code, set values (Product_ID) etc.

Is there anything I need to enter on the worksheet or select from the comboboxes to have the code run without me having to intervene.

I was able to recreate the problem but I don't see why it's happening.

What's the actual problem with the harmless 'detour'?

Why do you want to repeat the code?

Because if the user clicks on the white space of the combobox to type, instead of clicking on the drop button, then the list does not repopulate. I may also need to execute similar code in future additions that require me to take action when the combobox value changes.

For instance try selecting "Kahvaltilik" from the top box and then typing "bal" in the middle box. Press enter. Nothing happens. For this, I need to repopulate the list upon change and click as well. At least, that's how I think it works. Do let me know if I'm missing something here.