I am working with Excel 2013.
Someone may be know how to show the picture instead of URL. I have the URL list and by
VLOOKUP formula I want to display picture.
VLOOKUP I find the URL then I use
So when I type a new item code in the search field I need the picture to be shown.
Sub Test() Dim Pic As Picture Application.ScreenUpdating = False With ActiveSheet.Range("k19") Set Pic = .Parent.Pictures.Insert(.Value) With .Offset(, -1) Pic.Top = .Top Pic.Left = .Left Pic.Height = .Height Pic.Width = .Width End With End With Application.ScreenUpdating = True End Sub
However, every time I type a new code the picture does not refresh.
I have to run the module again.
And also maybe it is some extension to the script that could adjust the display size of the pic?