Displaying different images based on IF statement

M

manc

Active Member
Joined
Feb 26, 2010
Messages
340
Good morning Demigods,

In cell A1, the user chooses their name from a dropdown list.

I then have on file the users' signatures as images.

How can I get it to display in E1, for example, the signature/image that corresponds to value of A1?
Is it done using the IF statement?
Do I store the images on a seperate worksheet and reference the cell the image is in?

Your help, as always, is appreciated

Best regards
Manc
 
Last edited:

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
Dear Trebor76,

Thanks for your good spot regarding my thread. I tried following the solution but fear they are using an earlier version of excel to me (2007), so instruction 2 would not work properly. I could paste special but it wouldn't let me paste as a link, it was greyed out. So came to a dead end there. Thanks for your time though.

Regards
Manc


I found this link that I was going to try

http://www.andypope.info/fun/picviewer.htm

until repairman615 replied to my thread.


Dear repairman615,

Thanks very much for your post. What a superb tutorial. I shall give that a go and see how I get on. Thanks for your time.

Regards
Manc


Thanks to you both.
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question
Creating a Dynamic User form image without local files.
Replies
1
Views
292
jkpieterse
jkpieterse
cyrilbrd
  • Question
VBA display pictures in a table
Replies
2
Views
315
cyrilbrd
cyrilbrd
R
  • Solved
Help with worksheet_change
Replies
7
Views
469
rcicconetti
R
S
  • Question
Change object displayed based on cell value
Replies
1
Views
384
skpper
S
J
  • Question
Lookup cell in array with image
Replies
4
Views
681
BSALV
BSALV

Forum statistics

Threads
1,215,050
Messages
6,122,868
Members
449,097
Latest member
dbomb1414

Share this page

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
Back
Top