Programmatically Format Comments
 

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

Programmatically Format Comments
 

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

--
Regards,
Tom Ogilvy

"hglamy" wrote in message
...
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