formatting of comments

S

steve

Is it possible to format the font of the comments in various cells in a
particular sheet at once.Isit possible to change the taqhoma font to verdana
in the comment boxes all at once
 
D

Debra Dalgleish

You can do this with formatting. For example, the following code will
change all comments to Verdana, font size 12:

'======================
Sub FormatAllComments()
Dim ws As Worksheet
Dim cmt As Comment
For Each ws In ActiveWorkbook.Worksheets
For Each cmt In ws.Comments
With cmt.Shape.TextFrame.Characters.Font
.Name = "Verdana"
.Size = 12
End With
Next cmt
Next ws
End Sub
'========================
 
Top