Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With Range("d5")
.Comment.Visible = True
.Comment.Text Text:=Replace(.Comment.Text, "C'est qui par Tutatis?!", _
"C'est qui Tutatis?!")
.Comment.Shape.TextFrame.AutoSize = True
End With
Cancel = True
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Range("d5")
.Comment.Visible = True
.Comment.Text Text:="C'est qui par Tutatis?!"
End With
End Sub