+ Reply to Thread
Results 1 to 3 of 3

Show Image in Sheet in a specific area based on a click on a cell in the same Sheet

  1. #1
    Registered User
    Join Date
    03-23-2020
    Location
    vienna
    MS-Off Ver
    2016
    Posts
    2

    Show Image in Sheet in a specific area based on a click on a cell in the same Sheet

    Hello, my problem is this:

    I want to have various cells on the first sheet with different names ( like A, B..etc)
    when i click on such a cell i want that it shows me an image inserted in an other sheet (Sheet A, sheet B etc.) (or even better to a link on my computer where the image is stored) in a designated area of the first sheet where i have my buttons.

    I made this with inserting forms over the cell and linking them to the sheets where the picture is...and then linking the picture back to the first sheet with my named cells...
    but this is a lot of clicking and not a perfect solution..

    i attached a picture how i would like it to work,

    maybe someone can help me.

    thank you very much in advance.
    Attached Images Attached Images

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Show Image in Sheet in a specific area based on a click on a cell in the same Sheet

    .
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-23-2020
    Location
    vienna
    MS-Off Ver
    2016
    Posts
    2

    Re: Show Image in Sheet in a specific area based on a click on a cell in the same Sheet

    Thanks fpr the response.

    But i dont get it...?
    Will search for the Link2Picture comand, it might be useful.

    I dont now anything about Active X or macros yet...:-(

    Thanks aanyways.

+ 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. Replies: 2
    Last Post: 05-06-2018, 09:45 AM
  2. [SOLVED] Need a macro to show multiple images on a sheet based on the name of the image file
    By Nirmall in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-29-2015, 11:20 AM
  3. Insert image and image name into specific place on sheet
    By ACE23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2014, 04:41 AM
  4. Replies: 0
    Last Post: 02-28-2013, 03:11 PM
  5. Replies: 10
    Last Post: 09-05-2011, 03:45 PM
  6. copying cell values to specific area in sheet
    By Reinder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2007, 09:55 AM
  7. [SOLVED] click on cell takes you to specific sheet
    By Ron Tarr in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-08-2006, 04:35 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