ExcelBanter - Comment Font Size

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Comment Font Size (https://www.excelbanter.com/excel-programming/311788-comment-font-size.html)

Comment Font Size

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

Comment Font Size

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