VBA code to manage slicer items after selection crash constantly my excel. Need help.

Hello guys,

I am struggling with my dashboard and can't understand why i have a constant loop in my code when i select a slicer items. Then i have to restart my excel cause it crashes.

My goal is everytime i select one item slicer from my "Slicer_Industry" it triggers my module 5.

The code below is located in sheet3(customers) where is located my pivot table.

Please Login or Register  to view this content.

My module code is as per below

Please Login or Register  to view this content.

Appreciate your support If you can help i am not a programmer at all. Just trying to help my teammate.

Thank you in advance.

BR

TT

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new, I shall do it for you this time only: https://www.mrexcel.com/board/thread...-help.1255422/)

That's not a problem - the rule simply requires you to disclose WHERE ELSE you have asked the same question. This is a mandatory requirement if you choose to cross post.