add image to worksheet dependant on cell answer

[lesley burlingham]

Hi

I have seven images I need to have them show on the workbook when they are selected from a combo box. I have the images stored in another worksheet.

 

[Luke M]

Welcome to the forum!
Here's one example of how to do it using INDIRECT.
http://excel.tips.net/T003128_Displaying_Images_based_on_a_Result.html

No macros needed, either.

 

[lesley burlingham]

Thanks for this. I have seen this example. I get 'reference is not valid' when i try to give the picture a name of =picture

 

[Somendra Misra]

Hi,

See below link Comment #3.

http://chandoo.org/forum/threads/pic-formula.20088/#post-121371

Regards,

 

[lesley burlingham]

Thanks. I am still getting the referce not valid error when i try to add the name to the picture.

 

[Somendra Misra]

@lesley burlingham

Kindly upload your sample file.

Regards,

 

[lesley burlingham]

Hi

I did and forsome reason mine wont alow the =pic_2 but the sample file does. Cant figure out why.

 

[Somendra Misra]

Can you upload your file here.

Regards,

 

[lesley burlingham]

Sorry I read the last message completely wrong. I would like the image A1 on Contract to change everytime the data in A19 changes. The answer in A19 is controlled by a combi box on Request sheet B50.

 

[Somendra Misra]

See your file.

Regards,

 

[lesley burlingham]

I sdont know what you did, but it worked like a charm. Thak you so much it has been bugging me for agaes.