Results 1 to 3 of 3

Get / Search Selected Pivot Items

Threaded View

  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:
    
    Sub GetPivotFilters()
    
    With ActiveSheet.PivotTables("PivotTable1")
        .PivotFields("Case Type")
        .PivotFields("Work Type")
        .PivotFields("Service")
    
    End With
    
    End Sub
    Any help greatly appreciated
    All the best
    V
    Attached Files Attached Files

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. [SOLVED] 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. [SOLVED] 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. 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. 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