Trying to Shorten/Simplify some Code to Make it Easier to Apply To Other Workbooks

[Jim Clayton]

Perhaps I'm getting greedy. One of the forum contributors (Roel Jongman) was able to come up with a working solution to my slicer hiding problem (thanks again). But it's a bit of a mouthful code-wise and going forward I'm going to have a difficult time applying it to my current project as I start to add more things in...primarily due to my limited VBA knowledge. I'm wondering if there's a way to simplify it. Think the previous post was something along the lines of Dependent Slicers. Any help would be greatly appreciated. Tks.

[Logit]

.
If you can "sort" all the data based on the MATERIAL column alone, then you could use the Excel built-in FILTER method located on the DATA tab.

Here is an excellent "HOW TO" video that's only 8 minutes long : https://www.youtube.com/watch?v=EF9a5XuOu2w

It doesn't get much easier than the FILTER.

[Jim Clayton]

Thanks for the reply. Unfortunately I don't think that this is an option for me. On many of the parts that I intend to load in the future, "Material" would be non-applicable, and which would mean that the slicer would need to hide. Which is one of my reasons for seeing if it's possible to simplify it. The code works great for the current workbook, but it makes adding any future hide-able slicers a little difficult. I'm able to follow/manipulate some coding, but this is rather lengthy and beyond the scope of my capabilities, so I'm hoping maybe it can be simplified.

[Logit]

.
If you weren't going to use the SLICER approach ... is there anything in the existing database that you can 'search' on and return the data you require ?

The reason I ask ... I have another project that allows you to search the entire sheet at once. For every letter or number you enter into the search field, it returns anything it can find
with the letters / numbers in the order typed in. Hope that makes sense.

Sorry I do not have any experience with SLICERS.

[Jim Clayton]

Hi thanks. I think I'm planning sticking with the slicers. This is my first time dealing with them as well,but I'm working on building a platform where users can have all of the components needed to assemble a BOM on CAD drawings. The slicers allow for all the components to be laid out like command buttons with sub categories for filtering and narrowing down to one option. Once you've made your choice,you add it to your BOM on the adjacent page. The problem is that not all components have the same filter information,so I'm trying to hide them when irrelevant. Roel Jongman came up with a way to do this,but it's difficult for me to apply to future applications. Tks.

[Jim Clayton]

Anyone else think they might be able to crack this one? Would greatly appreciate the help. Tks.

[jeffreybrown]

Hello Jim & Welcome to the Forum,

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread titles and adjust accordingly...

[Jim Clayton]

Making query adjustments as requested. To summarize. The attached workbook has slicers. I was trying to hide the irrelevant ones when not in use. One of the forum contributors (Roel Jongman) was able to come up with a working solution to my slicer hiding problem. It works great for THIS workbooks, but is difficult for me to apply to OTHER workbooks with more slicers due to my limited VBA knowledge. Wondering if there's a way to simplify it. Thanks everyone for your help. Let me know if anything further is needed.