Pictures in Drop Down Selection

Would it be possible to insert pictures as a "comment" when a specific item is selected from a drop down?

I am working on an existing equipment parts spreadsheet and want to add pictures for each part number. The drop down selects the description and the item number is generated in a non-editable cell two columns to the right. See below screenshot. Ideally the picture would only appear when the mouse hovered over, similar to a comment. The picture display location isn't important as long as it could be displayed. The non-editable cells must remain, so no one changes the part codes by accident.

In a related thread additional text comments were able to be created in this manner. The thread was called "comments for drop down list items?", unfortunately I can't post a link at this time.

Screenshot Example.JPG

Thank you for the assistance!

Thanks Keebellah for the resource!

The challenge with this is the drop down will need the cell picture to change as well. I am able to insert a picture for one part number but the drop down contains multiple different items acting on the same active cell. Unless I'm not understanding the VBA correctly.

Correct. They can be jpg and stored in a separate folder.

I don't have much experience with userforms but if that seems to be the easiest method I'm open to that. Seeing the possibility of having a comment box update based on the selected drop down showed me this might be possible to do with pictures.

Thanks for the attention and response on this.

Sure, see attached spreadsheet. This is a small sample of the existing sheet but it has the same functionality.

I couldn't attach pictures in excel due to size limits. The photos I tried to attach were much too large of a size. Any photo will work, sorry I couldn't include this.

That is exactly the functionality needed. Thank you.

There was an error though. I updated to the file location but the picture isn't being found. I verified the file type is a ".jpg". See attached. The two pictures in the file are named "Equipment B" & "Equipment C".

Do I need to name the pictures anything specific?

Fixed. I should have assumed that. I have two last questions in scaling this up.

1) How can I scale this so it applies to many cell rows with a gap between cell rows? The final spreadsheet will have 4-8 consecutive rows followed by a spacer cell, and this will repeat. See picture for final format.

2) I increased the scale value but the image did not become larger, is there another part of the code to modify for a larger image?

I encountered an image path error, see attached. This was the same file location that worked with the previous method so it seems to be the correct location.

The final format will have a column ("Qty") between the description and part code. Would I just change the "target offset" from 1 to 2 to correct for this? I attached the formatted sample.

Thank you, this works well. Do you have any advice on copying the code to a new workbook?

To put this in action I will need to apply this code to the final spreadsheet. When I tried to create a new sheet I received the attached error. I renamed the modules and verified the new name was changed in the code when called for.

Thank you for the effort and time on this project. I will need to apply this to the main spreadsheet but I consider this solved.