Bonjour,
les commentaires se mettent à jour en quittant la feuille Enr.
Private Sub Worksheet_Deactivate()
Dim datas, c As Range, lig As Long
datas = [A1].CurrentRegion.Value
For lig = 2 To UBound(datas)
Set c = Sheets("SUIVI").Columns(2).Find(datas(lig, 2), , xlValues, xlWhole)
If Not c Is Nothing And datas(lig, 5) <> "" And datas(lig, 6) <> "" Then
With c.Offset(, datas(lig, 6))
.ClearComments
.AddComment Format(datas(lig, 5), "dd/mm/yyyy")
.Comment.Shape.TextFrame.AutoSize = True
End With
End If
Next lig
End Sub
eric
edit : ajout fichier oublié