Insert Pic based on Selection

[rfletcher35]

I have a sheet called "Main" In Cell B3 I have a drop down list, Whatever I choose here I want a picture to appear on Main starting in Cell E3

I can either have the pictures stored on another Sheet or from a Folder which ever is easiest, by choice i'd like it to locate the pic from another sheet.

This doesn't sound too complicated but I can't get my head around it.

Please help me!!!


Fletch

 

[Anthony47]

I guess that you mean "a different picture for each value you will input in B3"

For example:
-load the images directly in sheet Main
-make sure that the name of the images is exactly the value that you will input in B3 (that is, create a validation list using the images name)
-right-click on the tab with the name Main; chose Display code, to open the macro editor; copy the following code and paste it into macro editor:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim SHP As Shape
If Target.Address = "$B$3" Then
    For Each SHP In ActiveSheet.Shapes
        If SHP.Type = 13 Then
            If SHP.Name = Target.Value Then
                SHP.Visible = True
            Else
                SHP.Visible = False
            End If
        End If
    Next SHP
End If
End Sub

Now if you select a value in B3 only the corresponding image should be visible.

Bye