Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [A:A]) Is Nothing Then _
If Target.Value = "A" Or Target.Value = "B" Then Commentaire Target, Target.Value = "A"
End Sub
Sub Commentaire(c As Range, b As Boolean)
On Error Resume Next
c.Add.Comment
c.Comment.Text "" & IIf(b, "Bonjour", "Bonsoir")
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Target.Comment Is Nothing Then
SendKeys "%IM"
Cancel = True
End If
End Sub
Bonjour
Shift F2 permet aussi d'accéder au commentaire sans macro...