Excel Cell + Image

  • Thread starter Thread starter smd111
  • Start date Start date
S

smd111

Hi,

I am looking for option of inserting image to excel cell.

problem is i have more then 25000 images, manually inserting will take
year to do
So need solution that works fast...and can show all images at
referenced cell. so we can filter images.

suppose image name is "apple" in one colum.. then image should display
apple

"banana" then it should show banana....we can do this with filter
option of excel

but only if..we able to insert the images..in cell

i don't know how to do it quickly.
 
To insert and set the position of a picture:

Sub InsertPicture()
ActiveSheet.Pictures.Insert("C:\My Documents\My Pictures\Blah.gif").Select
'Line the picture up with cell G10, for example
Selection.ShapeRange.Left = Range("G10").Left
Selection.ShapeRange.Top = Range("G10").Top
End Sub

You could write this as event code to take the current selected value and find that file, or use a
lookup table...

HTH,
Bernie
MS Excel MVP
 
Back
Top