Edit Comments Formatting

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

How would I edit the formatting of more than one comment
in Excel? I am not familiar with Visual Basic, but I know
I might be able to change the New Spreadsheet Template.
However, I want to know if I can the formatting to a pre-
existing spreadsheet.

I know I can search comments by the following list of
commands:

F5
Special
Comments
OK
Ctrl+F

However, how would I change the formatting from 8 inch
Tahoma to 10 inch Arial without changing the formatting of
the cells?

Help would be appreciated. Thank you.
 
The following code will format all comments in the active workbook:

'===================================
Sub FormatComments()
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 = "Arial"
.Size = 10
.Bold = False
.ColorIndex = 0
End With
Next cmt
Next ws
End Sub
'================================
 
Back
Top