How to add multiple image to describe for each item (row) in excel.

[quocthai]

Hello everyone,
I have a file list of items (like images). I want to add an image to describe each item in the file.
Please advise and guide me on what i have to do.

Some ideas:
1.Take actual photos -> add all photos at once -> refer back to the location of the photo to match the item description.
2. Upload photos into online platform (like onedrive0 -> use image or QR function to upload photos.

I would like to say more about that purpose: There are some items that after reading the description, I still can't remember what it is. So if there is a photo to remind me, it will be much more convenient.

 

[jolivanes]

Where are the images stored?
Are the corresponding names equivalent to the Values in Column A?
How big do these images need to be? Fit in a cell?

 

[jolivanes]

In following example, the picture names including extension are in Column B starting at the 2nd Row.
Pictures will be placed in Column C and sized to the cell.
Change references as required.

Sub InsertPictures()
Dim sFolder As String
Dim sFile As String
Dim i As Long
Dim w As Worksheet
sFolder = "C:\Equipment Pictures\"    '<----- Where the pictures are. Change as needed
Set w = ActiveSheet ' or a specific sheet
For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row
    sFile = Dir(sFolder & Cells(i, 2).Value)
        w.Shapes.AddPicture Filename:=sFolder & sFile, _
            LinktoFile:=False, SaveWithDocument:=True, _
            Left:=Cells(i, 3).Left, Top:=Cells(i, 3).Top, _
            Width:=Cells(i, 3).Width, Height:=Rows(i).Height
Next i
End Sub