+ Reply to Thread
Results 1 to 3 of 3

Get / Search Selected Pivot Items

  1. #1
    Registered User
    Join Date
    10-27-2012
    Location
    Uk
    MS-Off Ver
    Excel 2010
    Posts
    98

    Get / Search Selected Pivot Items

    Hi Everyone

    This forum has a way of making me feel like anything is possible, but I might be reaching too far this time

    Is there any way (using VBA) to get a list of selected pivot filter items only?

    I need to be able to check if the user has selected any pivot items LIKE '%HAQ%' in the following 3 pivot fields.

    Or perhaps a list isn't even necessary. Can the selected pivot items be searched for any containing 'HAQ' then produce and TRUE/FALSE result?

    Tables filtered by:
    Please Login or Register  to view this content.
    Any help greatly appreciated
    All the best
    V
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,124

    Re: Get / Search Selected Pivot Items

    This will print information to the immediate window about fields and items.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-27-2012
    Location
    Uk
    MS-Off Ver
    Excel 2010
    Posts
    98

    Re: Get / Search Selected Pivot Items

    Hi Andy

    This is brilliant, it helped me to discover what was going on with the TRUE/FALSE results for the other filters also
    (different results depending on whether 'Select Multiple Items' is checked)

    Really helpful
    Thank you
    V

+ 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. Get Pivot Filter Selected Items
    By vwhite in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2020, 06:57 PM
  2. Return a value for items selected in a pivot filter
    By BaxBax in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 11-29-2013, 09:12 AM
  3. Replies: 1
    Last Post: 09-03-2012, 10:03 PM
  4. items disappearing from pivot dropdown when not selected
    By confused in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2006, 09:45 AM
  5. items disappearing from pivot dropdown when not selected
    By confused in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-19-2006, 09:35 AM
  6. [SOLVED] items disappearing from pivot dropdown when not selected
    By confused in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-19-2006, 09:30 AM
  7. [SOLVED] Prevent new pivot table items from being selected
    By Tom in forum Excel General
    Replies: 3
    Last Post: 08-10-2005, 01:05 PM

Tags for this Thread

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