+ Reply to Thread
Results 1 to 6 of 6

Finding Our Selected Slicer Value

  1. #1
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Finding Our Selected Slicer Value

    Hi,

    I have an Excel Table (ListObject) which has a Slicer connected to it. (PivotTable is not available)

    All I want is to retrieve the selected Value/Values on the slicer?

    Can anyone help?
    Cheers!
    Deep Dave

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: Finding Our Selected Slicer Value

    Something like below.
    Please Login or Register  to view this content.

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Finding Our Selected Slicer Value

    Hi,

    Thank you very much!

    Rep added..

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: Finding Our Selected Slicer Value

    You are welcome and thanks for the rep
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  5. #5
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Finding Our Selected Slicer Value

    Actually I had another requirement which I forgot to put up in the main post.

    I Could retrieve the Selected Values using a bit different method than yours, however I would like to run the code as soon as the Slicer Values are selected on the slicer.

    I am unable to do it. Any suggestions?

    I am sorry if my question sounds basic, but I am not very good with VBA..

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: Finding Our Selected Slicer Value

    It's not a basic question

    There is no Event handler that captures Slicer item selection. If the slicer was for PivotTable, you'd be able to use PivotTable_Update event to trigger the code.
    There is Worksheet_TableUpdate event as well. However, since slicer does not update tables, this can't be used.

    Workaround is to set up some out of way cell with following formula (I used cell K1)
    =SUBTOTAL(3,Table1[ColumnName])=COUNTA(Table1[ColumnName])

    It will return True when all items are visible (i.e. selected) and returns false otherwise.

    Then you can use Worksheet_Calculate event like below.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Default Slicer view to no data selected
    By zykkzxxy789077 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-14-2016, 03:55 AM
  2. Finding Items NOT selected on a Slicer
    By david2003 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-05-2014, 08:13 AM
  3. Use selected data from slicer
    By Tjken in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-22-2014, 07:18 AM
  4. Two different Charts based on selected slicer field
    By superglenntot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2014, 02:03 AM
  5. Copy selected value from slicer
    By merdle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2014, 04:56 PM
  6. VBA for displaying selected slicer in cell S7
    By crobledo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2013, 03:14 PM
  7. Replies: 2
    Last Post: 04-18-2013, 09:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1