Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ms excel IF Statement w/pictures?
is there a way to write a
statement in Excel (like an IF Statement), that would display a specific picture if a certain #/word/etc is typed in a cell? For example in A1 if I typed in ball, it would automatically bring up a pic I have saved of a ball in B1, whereas if I typed dog, it would put a dog in B1, etc..? If you know how to do this can you PLEASE email me at as its hard for me to check the Ngs at work... Thanks in advance Scott |
#2
|
|||
|
|||
You would need VBA, here's one solution
http://www.mcgimpsey.com/excel/lookuppics.html it's not IF function per se but you you can use a lookup instead of an if function in most cases -- Regards, Peo Sjoblom "Scott" wrote in message om... is there a way to write a statement in Excel (like an IF Statement), that would display a specific picture if a certain #/word/etc is typed in a cell? For example in A1 if I typed in ball, it would automatically bring up a pic I have saved of a ball in B1, whereas if I typed dog, it would put a dog in B1, etc..? If you know how to do this can you PLEASE email me at as its hard for me to check the Ngs at work... Thanks in advance Scott |
#3
|
|||
|
|||
Andy Pope has a unqiue method that doesn't require VBA.
It uses a XY scatter chart. You can download an example wb found on his website: http://www.andypope.info/fun/picviewer.htm HTH Jason Atlanta, GA -----Original Message----- is there a way to write a statement in Excel (like an IF Statement), that would display a specific picture if a certain #/word/etc is typed in a cell? For example in A1 if I typed in ball, it would automatically bring up a pic I have saved of a ball in B1, whereas if I typed dog, it would put a dog in B1, etc..? If you know how to do this can you PLEASE email me at as its hard for me to check the Ngs at work... Thanks in advance Scott . |
#4
|
|||
|
|||
Well there is another way...
Use the old, hidden and almost forgotten "Camera button" ! Here is how to add the Camera Icon Button: Menu:Tools, Customize, Commands(tab) Click on Categories: Tools. 70% down there is a small Camera button. Drag and drop to your icon menu bar. Next here is an Example how to use your new Camera button to create a Dynamic Picture link. I hope you can follow: 1. Insert a red Circle (autoshape) and place it over cell D1. 2. Insert a green Circle and place it over cell E1. 2. Mark the cell where your red circle is located (D1) 3. Now Click the camera and paste where you want your 'picture' to be placed. 4. Click on your picture. The formula bar will show the cell reference =$D$1. Delete that reference and write instead =Circles 6. Next go to the Menu: Insert, Name... Define and insert a name called Circles and use the formula =IF(A1=1,D1,E1). This will focus the picture on either the Red Circle or the Green Circle. 7. Try to change the value in A1 and you will see that you picture will show a red or a green circle. This is the principle. Have fun Ola Sandstrom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
ms excel IF statement w/pictures? | Links and Linking in Excel | |||
MS Excel IF Statement w/pictures? | Excel Discussion (Misc queries) | |||
Excel Report Using IF Statement? | Excel Discussion (Misc queries) | |||
SQL Statement and Excel | Charts and Charting in Excel |