[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Connect a picture to a cell

Posted on 2014-08-23
Medium Priority
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
  • 3
  • 2
LVL 50

Expert Comment

by:Martin Liss
ID: 40280994
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
ID: 40281003
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 50

Accepted Solution

Martin Liss earned 2000 total points
ID: 40281009
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
ID: 40281017
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
ID: 40281018
thank you kindly - much appreciated

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
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.

873 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