+ Reply to Thread
Results 1 to 3 of 3

how to select slicer item from a range cell

  1. #1
    Registered User
    Join Date
    05-09-2017
    Location
    montreal
    MS-Off Ver
    2013
    Posts
    4

    how to select slicer item from a range cell

    i would like if it is possible to select slicer item with VBA base on a selection of multiple cell. who is on another sheets.

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: how to select slicer item from a range cell

    Maybe this? (with handling of single cell too just in case)

    how do we know what slicer you are referring to?

    would you just enter it in the macro like below? or will it be the only slicer? (just use 1 instead of slicername)

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Registered User
    Join Date
    05-09-2017
    Location
    montreal
    MS-Off Ver
    2013
    Posts
    4

    Re: how to select slicer item from a range cell

    there is a file with what i want in the sheet number 3 there is 3 names a i want the slicer item get those 3 names as selected item.
    Attached Files Attached Files

+ 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. Have a cell equal to the value I select in a slicer?
    By qlikview in forum Excel General
    Replies: 1
    Last Post: 07-07-2015, 02:56 AM
  2. Workbook_Open to select first item in slicer/pivot
    By kev_33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2015, 01:08 AM
  3. Select Date Range from a Slicer with macro
    By ajadid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2014, 03:55 PM
  4. Newbie: Auto Select/un-Select an Range of Slicer Items
    By luckyali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 09:52 AM
  5. Selecting a Slicer Item in VBA
    By ManUBlueJay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2014, 08:21 AM
  6. How to auto select from a Slicer last or top item
    By xtrenge in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-07-2014, 06:22 PM
  7. Macro to select date range in slicer
    By handerson0603 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2013, 03:06 PM

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