Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
For Each commentaire In ActiveSheet.Comments
commentaire.Delete
Next commentaire
With Sheets('feuil2')
letexte = 'A1 = ' & .Range('a1') & Chr(10) & _
'A2 = ' & .Range('a2') & Chr(10) & _
'A3 = ' & .Range('a3') & Chr(10)
End With
Target.AddComment letexte
End Sub