Results 1 to 11 of 11

VBA to select value in slicer based on shape name

Threaded View

eivstei VBA to select value in slicer... 09-17-2023, 04:38 PM
Artik Re: VBA to select value in... 09-17-2023, 06:55 PM
eivstei Re: VBA to select value in... 09-18-2023, 02:58 AM
Artik Re: VBA to select value in... 09-18-2023, 03:45 AM
eivstei Re: VBA to select value in... 09-18-2023, 04:35 AM
Artik Re: VBA to select value in... 09-18-2023, 06:34 AM
eivstei Re: VBA to select value in... 09-18-2023, 06:56 AM
eivstei Re: VBA to select value in... 09-24-2023, 12:10 PM
Artik Re: VBA to select value in... 09-24-2023, 07:04 PM
eivstei Re: VBA to select value in... 09-25-2023, 12:20 PM
Artik Re: VBA to select value in... 09-25-2023, 06:51 PM
  1. #1
    Registered User
    Join Date
    09-17-2023
    Location
    Norway
    MS-Off Ver
    Excel 2016
    Posts
    6

    VBA to select value in slicer based on shape name

    Hi
    In the attached workbook, I have made an easy excample of what I'm trying to solve.

    I have a front page with shapes that will control the slicers in the other page. So if I press "USA", or "CA", it will choose that shape's name (or caption) in the slicer/filter value.

    The table is in the datamodel, and only as an "connection".

    I believe the country shapes need one macro, and the state-shapes a different macro, since it is two different slicers.

    I have tried so many VBA versions, without luck.

    Can someone try to make this work, thanks?
    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. Select Slicer Value based on range of cell values
    By avmax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2023, 07:37 AM
  2. Select Pivot/Slicer Value based on Cell Input
    By ptmuldoon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2022, 10:30 AM
  3. Replies: 0
    Last Post: 10-01-2020, 05:40 AM
  4. Macro to Select Shape Based on Filter
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2019, 04:28 AM
  5. A Slicer Is A Shape, Why Cant I Add A Macro
    By goss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2015, 10:45 AM
  6. [SOLVED] A macro after setting onaction for a shape that will select the shape.
    By vonRobbo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2014, 11:34 PM
  7. Select a shape based on a cell value and update the shape when value changes
    By BigAl99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2013, 12:06 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