Is it possibe to insert an image (such as Picture1 which is the name of an image created by Insert>Name>Define) using an IF statement as in:
=IF(A1=B1,+Picture1,"")
Is it possibe to insert an image (such as Picture1 which is the name of an image created by Insert>Name>Define) using an IF statement as in:
=IF(A1=B1,+Picture1,"")
Last edited by BRISBANEBOB; 06-02-2009 at 08:01 PM.
You could add a picture link with a formula simular to what you are asking.
I put together a sample file with the instructions.
That is brilliant!
Thanks - much appreciated.
Is it possible to detail this answer more.
I am at this section
3) Create a defined name with your formula (example : MyPic)
4) Copy a cell
5) Holding the Shift key select the Edit Menu
6) Select Paste Picture Link
7) Change the formula for the picture to =MyPic)
please advise on step 3 define name with formula
@stienus,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
Ben Van Johnson
I find this same solution in a number of places but each time with a horrid explanation.
Lets say I have two images that I want to toggle between via a formula:
The images will be referred to as Logo A and Logo B
Logo A is hovering over the cells A1:B2 --> This Range i have named LOGORangeA
Logo B is hovering over the cells C1;D2 --> This Range I have named LOGORangeB
Now the next step is to create a picture linked image
(And for anyone who doesn't know how to do this: select the cells behind the images (one at a time) and paste "As a Picture" picture linked image)
So I now have two picture linked images, one for each Logo. After which, I click on the Logo A and change the formula to =LOGORangeA and the same for Logo B, =LOGORangeB
At this point I have the two original images, two named ranges LOGORangeA & LOGORangeB, and now the two corresponding picture linked images that are named LogoA and LogoB respectively
What is the next step? The instruction line in the sample spreadsheet states, "Create a defined name with your formula (example : MyPic)"
What the heck does this mean?
I can create a named range called MyPic and go into the name editor and define a formula referring to the named ranges LOGORangeA and LOGORangeB as appears is what is done in the spreadsheet. But that does not work.
Where I am is stuck is how to define a function to toggle between the two images.
Thanks in advance
Real_Professional,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
See: Control the display of a picture using a formula / Insert image with IF statement
Note also that the correct way to ask a related question is to start your own thread and, where appropriate, as in this case, provide a link to the original thread.
FWIW: I think it would be appropriate to mark this thread as Solved and Close/lock it down ... Moderators?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thread mark as solved.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
@Arlette; thanks
Thanks Bro, you solved my problem.
A bundle of Thanks, you did a great job.
Hi chance2 do you still have your solution as it seems to be corrupted when I try to download it.
Many thanks
Paul
The thread is 8 years old and chance2 hasn't been on the forum since September 2016.
That said, the file downloads OK for me.
Thanks TMS,
I have it now I changed the file extension to .xls from .xlsx and it will now open and it works :-D, it had been saying missing file or corrupted.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks