IF, Then Statement using picture files?????

[Brw]

Will Excel allow you to insert a specific picture file
(*.jpg) based on the criteria of a cell?

i.e.
I have four employees that will fill in their initials in
a CELL.

Based on those initials I want Excel to go to a folder
where I have these four employees signature scanned in as
*.jpg files and insert the appropriate picture.

I tried IF..Then but it won't allow you to INSERT a
picture while doing a formula.

Any suggestions?

 

[Jim]

You can not do this with a worksheet formula, but it is possible with VBA.

 

[gary b]

Not quite what you intended (??), but how about combining
a nested IF... THEN statement with the "HYPERLINK
Worksheet Function" Look it up in Excel Help...

This won't put the picture in a worksheet cell, but will
create a hyperlink in 'next' cell (the link created
depends on the IF statement!) that opens the appropriate
photo.

Method #1004 of skinning the cat. YOUR mileage may vary.

gary b
(e-mail address removed)

 

[Guest]

After a quick test, that does not appear to work, Gary. Although it evaluates to TRUE, it does not actually insert a HYPERLINK; the cell becomes a link, but nothing happens. I believe, based on experience and the posts of others, that VBA is the preferred and most effective way to display pictures on a worksheet

Have a look at this for an example Be sure it is all in your Location Bar
http://groups.google.com/groups?hl=...c3428c%2426f8a570%24a101280a%40phx.gbl&rnum=1