formatting of comments

[Guest]

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

 

[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
'========================

 

[Gord Dibben]

Steve

 

[Gord Dibben]

Steve


Not sure, but maybe one of the subjects at Debra Dalgeish's site will help.

http://www.contextures.on.ca/xlcomments03.html


Gord Dibben Excel MVP