Sub versComm()
Dim X, Nom, repertoirePhoto As String
Dim Cell As Range
Dim Img As Shape
repertoirePhoto = "C:\LesDocuments\Downloads\Domimare\" ' Adapter
On Error Resume Next
With ActiveSheet
For Each Cell In Selection
Nom = Cell.Value
Set Cell = Cell.Select
.Pictures.Insert (repertoirePhoto & Nom & ".jpg")
.Shapes(Nom).LockAspectRatio = msoFalse
.Shapes(Nom).Left = Cell.Left
.Shapes(Nom).Top = Cell.Top
.Shapes(Nom).Height = Cell.Height
.Shapes(Nom).Width = Cell.Width
Cell.AddComment ' ajoute l'objet commenaire
Cell.Comment.Visible = False 'le commentaire sera masqué
Cell.Comment.Text Text:=Nom 'place le contenu de Nom dans l'objet commentaire
Next
End Wi