+ Reply to Thread
Results 1 to 3 of 3

Change object displayed based on cell value

  1. #1
    Registered User
    Join Date
    12-01-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Lightbulb Change object displayed based on cell value

    I have a list of countries in my Excel tool and each of them has their own PDF file content.

    I have embedded these PDFs as objects into the Excel tool, so that users of the Excel tool can open up the PDFs within the Excel file.

    In the dashboard, users can select a country from a dropdown list and I would like the corresponding PDF object to show up (i.e., the PDF files are not be displayed together, but only based on cell value).

    There are solutions online to change or insert images based cell values (named range + INDEX/MATCH + linked picture).

    I've tried taking the same approach for the objects, but it does not work. I'm wondering if anyone has an equivalent solution for Excel objects.

    Much thanks.

  2. #2
    Registered User
    Join Date
    07-24-2020
    Location
    Madhya Pradesh, India
    MS-Off Ver
    365
    Posts
    61

    Re: Change object displayed based on cell value

    Please attach a sample file for better understanding...

  3. #3
    Registered User
    Join Date
    12-01-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Re: Change object displayed based on cell value

    Hi,

    Please see the attachment for an illustration of the question. Thank you.

+ 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. [SOLVED] Change formatting based on displayed value
    By Mvaldesi in forum Excel General
    Replies: 3
    Last Post: 09-06-2018, 10:09 AM
  2. Change how name is displayed in a cell
    By acct-guy in forum Excel General
    Replies: 5
    Last Post: 08-31-2016, 12:59 PM
  3. Condensing what is displayed based on cell value
    By michdmbfan in forum Excel General
    Replies: 1
    Last Post: 02-09-2015, 02:00 PM
  4. [SOLVED] How to change which chart is displayed based on a cell value
    By Mubzie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2014, 11:58 AM
  5. Change way date is displayed in cell....
    By howardrg in forum Excel General
    Replies: 10
    Last Post: 02-02-2012, 01:55 PM
  6. [SOLVED] How to change no. of decimal places displayed depending on cell va
    By fulmodad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2006, 10:10 AM

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