Execute data label coloring code when drop down list changed

Hi,

I would need your help regarding a worksheet change event.

On Chart worksheet in cell C6 I have drop down list (with material numbers) and when this value change then the MinMaxLabelColoring code (<= working fine alone) should be called and executed, but this is not working.

Could you please help me to figure out the right way?

Please Login or Register  to view this content.

Thank you in advance the reply!

Hi CK76,

I checked your options but the problem is still open on my side.
Could you see the attached file?

You have Worksheet_Change event in Module1. Put it in "Chart" sheet module.

Looks to be working fine on my end when code is moved to "Chart" sheet module.

Thank you very much!