View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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