par exemple pour insérer le shape(triangle) sur la cellule sélectionnée uniquement,
Sub CoverCommentIndicatorOnSelection()
Dim pComment As Comment
Dim addrComment As String
Dim l As Integer, t As Integer
For Each pComment In ActiveSheet.Comments
addrComment = Range(pComment.Shape.TopLeftCell.Address).Offset(1, -1).Address
If ActiveCell.Address = addrComment Then
With ActiveCell
l = .Left + .Width - 5
t = .Top
End With
' expression.AddShape(Type, Left, Top, Width, Height)
Set pShape = ActiveSheet.Shapes.AddShape(msoShapeRightTriangle, l, t, 5, 5)
With pShape
.Flip msoFlipVertical
.Flip msoFlipHorizontal
.Fill.ForeColor.SchemeColor = 12
.Fill.Visible = msoTrue
.Fill.Solid
.Line.Visible = msoFalse
End With
End If
Next
End Sub