Linking Image to a cell value, and display the selected image in new sheet

Dear All,

I need to link an image to a cell value and display the selected image in a new sheet of the same excel.
I am attaching samplefile for easy reference. The requirement is, from the workout sheet when I select from drop down list, then the corresponding cell value appears in Parameter sheet in C9 cell.

There are four images copied in Parameter excel. The given image has to be selected and linked to the C9 cell value. Based on the selection that particular image should be shown on Sample Picture sheet. Here based on the selection only the image should reflect here.

Any help on this please. Appreciate your replies.

try to have the image sizes all the same and put the pictures one on top of other. then, use this code when the cell value changes:

Please Login or Register  to view this content.

what it does is it brings to the front the desired image. you need to change the name "Picture 2" to the corresponding name.

Dear Adyteo,

I have resized the images accordingly. Can you please update the sheet with your solution. so that it will be better in understanding for me. Please see the attachement.

Thanks in advance.

try it:
Attachment 305157

Dear Adyteo,

I am not able to open the attachment. Please provide valida attachement, that would be helpful.

Regards,
SV

I had to recreate it
samplefile.xlsm

Excellent Adyteo. Thank you very much. Able to replicate or linkage to the desired images.

As part of the query, when we select the drop down from the Workout sheet ('C' Column), the highlighted image from Parameters Tab should automatically send or show this image on Sample Pictures Tab in the same work sheet.

Kindly help with this query. Thank you in advance.

Regards.

sorry, I am not sure I understand your request.

Dear Adyteo,

The requirement is below:

From the Workout sheet when I select drop down list---> Image gets higlighted in Parameters sheet based on the option selected---> The highlighted image should automatically appear on Sample Picture sheet in the same excel sheet.

Attaching samplefile excel for your refernce.

Regards,
SV

I have recently came across the same kind of a thread! Have a look at it! Is this you want ?
http://www.excelforum.com/excel-gene...ml#post3632775

Like This ?

I think what you are seeking can be done without VBA. See the Name manager for Pic_Lookup formula. How to do is Detailed in link above

Thank you Hemesh for the help.

Able to replicate and solved my problem. Very good tips.

You are welcome and Thanks for the feedback Shiva!