Private Sub Worksheet_SelectionChange(ByVal Target As Range)
' On Error Resume Next
' Cells(Target.Row, 1).Comment.Visible = True
Dim cmt, c
Set cmt = ActiveSheet.Comments
For Each c In cmt
c.Visible = False
Next
If Not Target.Comment Is Nothing Then
Target.Comment.Visible = True
Target.Comment.Shape.Top = Target.Top - 1
Target.Comment.Shape.Left = Target.Left - 65
'Target.Comment.Shape.TextFrame.AutoSize = True ' taille auto mais il faur recadrer le top et le left
Target.Comment.Shape.Height = 15
Target.Comment.Shape.Width = 65
Target.Comment.Shape.Fill.ForeColor.RGB = RGB(0, 0, 255)
Target.Comment.Shape.TextFrame.Characters.Font.Bold = True 'ecriture gras
Target.Comment.Shape.OLEFormat.Object.Font.Name = roboto ' type de police
Target.Comment.Shape.OLEFormat.Object.Font.Size = 8 ' taille texte
Target.Comment.Shape.TextFrame.Characters.Font.Color = RGB(255, 255, 255) ' vbYellow ' pour couleur différente du premier caractères = Characters(i, j - i + 1).
Target.Comment.Shape.TextFrame.HorizontalAlignment = xlCenter
Target.Comment.Shape.TextFrame.VerticalAlignment = xlCenter
cmt = Target.Address
End If
End Sub