Load Image base on the path in cell

[dreamerkan]

I would like to know if I can load the image from the Image path in the cell?

Can I control the size of image when the image is load?

 

[Taul]

You can adapt this to suit your page set-up; based on a directory structure of:-
Test/Images
Save your excel file in the parent (Test) directory
Create your images called pic1.png, pic2.png, pic3.png etc and save your images in the Image directory.
In cell A1 you can type “pic1” to display the image on screen.

Right click on the page tab and choose “View Code”, paste this into the right hand side of the page.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> "$A$1" Then Exit Sub
    Dim Pic As Picture
    On Error Resume Next
    Me.Pictures("PicTemp").Delete
    On Error GoTo 0
    Target.Offset(, 10).Select 'just sets where the cursor sits
    Set Pic = Me.Pictures.Insert(Me.Parent.Path & "\Images\" & Target.Value & ".png")
    Pic.Name = "PicTemp"
    
    'scale picture
Me.Pictures("PicTemp").Width = 200
'Me.Pictures("PicTemp").Height = 250
Me.Pictures("PicTemp").Top = 150
Me.Pictures("PicTemp").Left = 200

End Sub