chirayu
Well-Known Member
Hi Guys,
Related to thread:
http://forum.chandoo.org/threads/vba-slicer-userform-version.30524/
I was thinking of expanding the functionality on this by doing something I saw once in someone else's VBA Slicer. Forget whose but anyways, what I mean by the title is that - without adding a PivotField to either Rows/Columns/Values/Filters how can I apply a filter to that field & make that change visible in the Pivot?
You see I noticed that my macro does already apply the filter to the Field - even if it is not being used in either of those. But the change is not visible in the pivot itself till you move that field to one of those categories in the pivot configuration.
So I was wondering if anyone had any clue as to how I could do this.
Also just as an FYI - I have recently fixed a bug in the macro where hitting Unfilter without choosing a Pivot/Field from the dropdowns throws an error. Also I have added an extra button that Unfilters all fields in the entire pivot; and I have added an extra bit that will highlight the used filters in the selected field of the dropdown, so you don't have to figure it out yourself when changing fields. But won't be releasing a new version till I'm able to figure out how to do the above.
Also hit another hurdle. How do I check which items are visible in a report filter? as .PivotItems doesn't work for .xls files
Related to thread:
http://forum.chandoo.org/threads/vba-slicer-userform-version.30524/
I was thinking of expanding the functionality on this by doing something I saw once in someone else's VBA Slicer. Forget whose but anyways, what I mean by the title is that - without adding a PivotField to either Rows/Columns/Values/Filters how can I apply a filter to that field & make that change visible in the Pivot?
You see I noticed that my macro does already apply the filter to the Field - even if it is not being used in either of those. But the change is not visible in the pivot itself till you move that field to one of those categories in the pivot configuration.
So I was wondering if anyone had any clue as to how I could do this.
Also just as an FYI - I have recently fixed a bug in the macro where hitting Unfilter without choosing a Pivot/Field from the dropdowns throws an error. Also I have added an extra button that Unfilters all fields in the entire pivot; and I have added an extra bit that will highlight the used filters in the selected field of the dropdown, so you don't have to figure it out yourself when changing fields. But won't be releasing a new version till I'm able to figure out how to do the above.
Also hit another hurdle. How do I check which items are visible in a report filter? as .PivotItems doesn't work for .xls files
Last edited: