With .Cells(lig, col) .AddComment ' si le commentaire n'existe pas .Comment.Text Text:=blabla With .Comment.Shape .Width = 150 .Height = 100 .OLEFormat.Object.Font.Name = "Courier New" .OLEFormat.Object.Font.Size = 20 .OLEFormat.Object.Interior.ColorIndex = 34 ' bleu clair .TextFrame.Characters.Font.ColorIndex = 11 ' bleu foncé .TextFrame.Characters.Font.Bold = True End With End With