LinkBack URL
About LinkBacks
Hi!
How can I insert a picture based on cell value without using VBA?
For example:
If A1>10 ----> Then show a chosen picture in B1
Hi!
How can I insert a picture based on cell value without using VBA?
For example:
If A1>10 ----> Then show a chosen picture in B1
I've done some pretty intensive research on the subject, and as far as I know, this is not possible without the use of VBA (unless you make your own character in the character editor tool and use that instead).
Spread the love, add to the Rep
"None of us are as smart as all of us."
How many different pictures are we talking about?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Attached is an example with two pics. Each picture has to be set up separately as described by Ron here
http://www.excelforum.com/excel-form...n-cell-a1.html
In My example, A1 is a number. In H1 is a formula
=IF(A1>10,"dragon","goblin")
I set the font to white so you can't see it.
The defined name (as per Ron) ShowMyPic = INDIRECT("pic" & $H$1)
Great! Thank you very much! Just what I was looking forOriginally Posted by ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks