call an image with a formula

[Dvalle71]

Hi, Somebody can help me to find how call an image (stored in another sheet) with a formula?


Example:


in Cell A1 I type 123 then in cell B1 shown a picture stored in other sheet with name 123
then if re-type 124 in cell A1, this change the picture stored as a 124
Images .jpg

Regards

Daniel

 

[pgc01]

Hi Daniel

I posted how to do it here:

http://www.mrexcel.com/forum/excel-questions/760583-changing-picture.html

in post #5, but you should read the whole thread.


Remark:

I just noticed that in line 5 of the post there is a typo:

Instead of A2 in

"Each time the value in A2 changes, the corresponding picture is displayed.", it should be B2.