Working with Slicers in Excel VBA | Pt. 2

[@AnilKumar-vi8oe]

Very good contents, great work..Keep sharing knowledge

[@SigmaCoding]

Thanks a lot

[@AniManuSCh]

Nice. I had been trying to make a macro to toggle the header visibility of only slicers that are selected and also to change its font size to be divided by 1.5 of the max font size of the column it is located. So lets say I hava a slicer fitting from E1 to E9 and in E10 a table with more than 5 data values so the slicer will have to had a scrollbar wich maybe limit the read visibility of the items, but also any other slicer could be added in fitting position above any other table field and even fom a diferent table. (so nothing can be hardcoded since it has to figure out respective table and table fields columns) So how through VBA: 1-make the slicer fits in size and position above its respective table field header (Rows 1 to 9, and wichever column it may be) if user decide to add it. 2-(no matter the style it could have) make it have the font size in a fitting visibility to read the items in view like same max font size of the column in wich the slicer is positioned or that divided by 1.5 or something like that depending on the slicer having a scrollbar or not to have the most complete read of the items 3-Change Selected Slicers header visibility: Slicer header visibility = toggle

[@3danim8r1]

Can we assign macro to slicers and both should work( slicer and macro) when we use slicer...

[@dainluso]

Great video! I learned a lot about working with slicers. Will you still do the third video you mentioned? If so, could you show how to control a slicer B by selecting an item in slicers Ak? I'd love to learn about that.

[@carlosrobertomartinezandra9120]

Hello, it is a pleasure to see this type of content, a question, do you have a video in which each item of a slicer can be whistled in a different color, for example? I have a "category" slicer and has the following items 1. warehouse 2. store 3. purchases then in the slicer on the slicer button store this red color on the store slicer button this is yellow on the slicer button you buy this one green is it possible to do that?

[@Javier-vl8hf]

Is there a way to insert a timeline slicer via code?

[@teuteu13]

How can i call a macro via slicer item?

[@gregsdoodles4547]

What's the benefit of adding slicers this way vs just clicking on insert -->slicer in Excel?

[@nicolefleming8787]

Hi! I'm pretty new to VBA but these videos are AWESOME! I got into it just today because I have a series of emails that I right now need to manually copy and paste tables from a pivot table into outlook emails (two tables per email). So basically filtering, then copy/pasting, copy/pasting, filtering for something new. Is this something possible and are there topics I should explore more to try to automate this somehow? I know it seems like a really ambitious project for someone new, but this is a process about 50 people do 100+ times within a month each year and I'm curious if I can make it faster and easier. Thanks!

[@SigmaCoding]

Hey Nicole, thanks for the suggestions I thought it was an interesting topic, so I made a video on it this morning. Here is the link to the video: kzbin.info/www/bejne/gJvFp4eknLmlY68 The link to the Workbook: facebook.com/groups/sigmacoding And the Code on GitHub: github.com/areed1192/sigma_coding_youtube/blob/master/vba/vba-outlook/Excel%20to%20Outlook%20-%20Pivot%20Tables.bas Hopefully, this helps out with your project.

[@vaishakmuralidharan7605]

@@SigmaCoding wow, you deserve more subs and likes. Great work, Mr. Sigma!

[@RLB52]

Would be interesting to putting the slicer in a form object instead of on the worksheet.