Images In Excel

L

Legacy 48831

Guest
Is is possible to show an image either in a cell or maybe link to an online image so that when a selection or cell contains a certain value the image will appear? I know that I can place an image within a comment box but it does not look very professional.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
L

Legacy 48831

Guest
Thanks for your reply. That is not quite what I am looking for. I searched the boards for some time and came across this post:

http://www.mrexcel.com/board2/viewtopic.php?t=57281&highlight=image

at the bottom there's a zip file with a sheet that looks like what I want to do but I can not understand how he made this work. What I need to do is make the image change based upon a cells value like A1 with a value of 1 might be cause a picture of an apple to appear, if the value of cell A1 were to be 2 it would cause an image of an orange. Can anyone tell me how to do this like they did in the previous post zip fle?
 

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi again tm1274,

Yes, the method demonstrated by the zip file is very clever and should work well for you if you only have a few (pictures to choose from). If you have a lot--say more than four or five, this starts to get unwieldy because the formula used to define the picture assigned to the name gets long and complicated. There are two things you should look at in that example, the first is the second sheet (Pictures) which has all the pictures on it, and they are named (select each one an look at the Name box just above cell A1) and placed in cells A1, B1 and C1. The other is the formula assigned to the name PictureReference which is used in the formula assigned to the picture on Sheet1. Go to Insert > Name > Define and look at the formula assigned to PictureReference. You must replace this formula with a similiar formula that yields the cell containing the appropriate picture based on the value of the cell on the main sheet.

The VBA-based approach is much more flexible and can easily handle almost any number of pictures. This method works well with numbers, text strings, etc., to identify the picture that should appear. It becomes really easy if you can name the picture the same as the text string in the cell, so also works easily with large dropdown lists.

In addition, it doesn't require another sheet to store the pictures on--they can be stored invisibly on the sheet you want them to appear on, positioned right where you want them to appear. Perhaps the following posting will help if you want to use this method:

http://www.mrexcel.com/board2/viewtopic.php?t=135205&highlight=pictures

Keep Excelling.

Damon
 

Forum statistics

Threads
1,140,937
Messages
5,703,260
Members
421,289
Latest member
fbohlandt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top