Announcement

Collapse
No announcement yet.

VBA Slicer Userform version

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16


    I was just checking the file when I noticed a pretty big bug, so I'm releasing v2. To replicate & view this bug - do as follows using v1.

    Create the POL slicer. Select some items & Filter. Then hit invert. You'll notice that the first time it appears to do nothing & from then on the ListBox selection appears to be the Inverted version of the Pivot every time you click the Invert button.
    Redtube Beeg Spankbang
    This was due to the fact that I was Inverting the ListBox selection before running the code; and since the code is using ".PivotItems.Visible = Not .Listbox1.Selected" the 1st invert essentially = the already filtered pivot.
    Last edited by toucherts; 2 weeks ago.

    Comment

    Working...
    X