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
|