Connect a picture to a cell

Posted on 2014-08-23
Last Modified: 2014-08-23
The image below it what my objective is. I created it manually.
In the attached workbook on the Main Menu the user selects Category that lists Topics associated with that Category and when the Topic is selected a brief Description is provided. In the attached workbook I have only 1 Topic - Line Charts where I've entered in a Description. Is it possible that when a Description is displayed then a picture of the particular chart is also displayed that is associated with the Topic? I tried embedding an image where I enter the Description but nothing appeared.
Picture to cellExcel-Dashboards-Rev.xlsm
Question by:Frank Freese
    LVL 44

    Expert Comment

    by:Martin Liss
    You can put a picture in a cell but I believe you need to first Insert a shape/picture. You might be able to do that but IMO you are going a bit overboard because I assume that the user can see the same picture and more by double-clicking the Topic.

    Author Comment

    by:Frank Freese
    You're correct on all points.
    However, let's say that in the section under Description I insert a shape. How would one tie a particular picture to the shape to the Topic. Or can they?
    LVL 44

    Accepted Solution

    You can probably figure out how to do it on a one-time basis on a sheet. If so do it again while recording a macro and then extract the code from the macro and it to your current Main sheet code and modify it so that it's generalized for different pictures.

    Author Comment

    by:Frank Freese
    I like that idea! Thank you (may not move on it but it helps me to remember to try creating macros first)

    Author Closing Comment

    by:Frank Freese
    thank you kindly - much appreciated

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now