There's some sample code for formatted comments he

http://www.contextures.com/xlcomments03.html#Formatted

Sheldon wrote:
In code how do I change the comment font size?

I am creating the comment as follows

Sheet3.Range(strCol & strRow).AddComment
Sheet3.Range(strCol & strRow).Comment.Visible = False
Sheet3.Range(strCol & strRow).Comment.Text strComment
Sheet3.Range(strCol & strRow).Comment.Shape.TextFrame.AutoSize = True


Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html