Hello - looking to have images populate in a cell based on a selection made in a dropdown (data validation list). I came across this link from a previous thread, and it got me halfway there...

http://www.mcgimpsey.com/excel/lookuppics.html

On my sheet, I have two separate dropdown menus which use two separate lists....I also have two different lookuptables for pics on a different sheet, linking the image name to the dropdown selection (PicTable1 and PicTable2). I'm not duplicating images between the lists...they're all independent, just on the same sheet.

Here is the code...when I entered my reference cell in this code, it worked fine. However, the images next to the second dropdown are blank...I tried duplicating various parts of the code to get it to work, but no luck. Here is the code from the link...replace range "F1" below with the two areas that I want to put the pictures.... "A6" and "M6"

Private Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("F1")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
End Sub