Programmatically Format Comments

  • Thread starter Thread starter hglamy
  • Start date Start date
H

hglamy

Hello there,

how can I format different aspects of a comment
such as font color etc. by way of vba ?

Help is greatly appreciated.

Thank you in advance.

Kind regards,

H.G. Lamy
 
Use the characters method.

Sub modify()
Dim cmt As Comment
Set cmt = ActiveCell.Comment
With cmt.Shape
With .TextFrame.Characters(7, 8)
.Font.Size = 16
.Font.ColorIndex = 3
.Font.Name = "Times New Roman"
End With
End With
End Sub

as an example
 
Back
Top