How to make a picture appear depending on what a cell says

[Ayoub99k]

Okay so currently im using this formula =INDIRECT("'"&A16&"'!G25")

If A16 says Sheet1 then the cell which has the above code will put what G25 says in sheet1. And if i write sheet2 in cell A16 then the cell which i put the above code will display the data in cell G25 from sheet2.

I want to do the same except for a picture. So if i type Sheet 1 in cell A16 a picture from sheet 1 will be shown. but if i type sheet 2 in cell a16 then a pciture from sheet 2 will show.

Any possible way to do this?

[gbeats101]

i doubt you can do it using formula but here is some VBA that might help you achieve this, it will need adapting to you needs but its working as a concept.......just message back and someone can help you integrate it if you need help

Please Login or Register  to view this content.

[bakerman2]

Use Image-Control and LoadPicture. Much simpler and more universal since not everyone already works with XL2013

[gbeats101]

@Bakerman2, nice point i didnt realize it wasnt available until 2013, however wouldnt it be better using the 'Sheet.Pictures' instead of relying on objects? excel never seems to handle Ole Objects very reliably or efficiently...