Select Pivot Slicer Item when A1 Value Changes
I'm trying to select an item in Pivot Slicer when I change "A1" value.
So when I change the "A1" value to "ABC" the code should look for "ABC" in the Slicer Item and select it.
"A1" value will be same as the items in the slicer.
Here is my try, but doesn't seems to work and doesn't look right
Thank you for help!
Please Login or Register to view this content.
This worked for me in a very simple test.
If you still need help post example workbook which illustrates the problemPlease Login or Register to view this content.
This works, I was missing the .ClearAllFilters
Thank you!
If I want to do the same for Pivot table filter instead would my code look something like this?
Looks like I'm missing .Visible property and othersPlease Login or Register to view this content.
I added the ManualUpdate because I don't want to refresh on each status change. But not sure if I did it correctly
Last edited by ggmkp; 10-18-2019 at 11:37 AM.
Code works for me.
If it is not doing what you expect then post example workbook to illustrate the problem
I'm getting an error at "Field.CurrentPage = A1Value".
Reads "Run-time error 1004. Unable to set CurrentPage property of PivotField class".
This is probably because I'm reading from CurrentPage but have pivot table is in a different sheet ("Sheet2")
And I have this code in Sheet 1
Last edited by ggmkp; 10-21-2019 at 03:25 PM.
I tried to change it to filter the Row Label instead:
But now I get a compile error "Named argument not found" at .PivotFilters.AddPlease Login or Register to view this content.
I tried adding quotation on "A1Value" but with or without I'm getting same error.
I have the code in Sheet 1, and the Pivot table is in Sheet 2.
I figured it out.
It's not Type:=xlValueEquals
It's Type:=xlCaptionEquals
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks