Linking Picture to Cell Value

[sdx013]

I'm a newbie so please bear with me if this has been asked and answered or if I'm posting in the wrong area.

I'm trying to create a worksheet (worksheet A) that when I select a cell with a description (for example A1, A2, A3 have a description of a part) then cell C1 will show a picture of what was selected. I'm trying to do this by creating another worksheet (worksheet B) that will have all the pictures within it and have each picture associated with a cell. My thought process is that if picture 1 is = to cell B1 on worksheet B then on worksheet A I can write a macro that says if cell A1 is selected then C1=worksheet B (B1). Does this make sense? If so, how do I get the pictures linked to cells on worksheet B so that I can do this? Thank you in advance for any help that you can give.

After searching for different keywords I think I found where this was asked by another member so I should be good...If I knew how to delete this post I would.

[dflak]

I think this does what you want.

The pictures sheet is where you put the pictures and give them their names. There is also a table on this page where you match part names to picture names.

Cell B1 on the Order Sheet is *supposed* to be a drop-down validation only for some unknown reason the drop-down works once and then you have to save the worksheet if you want to make it work again. That is an issue I will troubleshoot some other time. This kind of thing works for me all the time in other worksheets.