Comment Default Font Size

[John M]

Hello,

Does anyone know how I can change the default font size of
the comment feature in Excel? It currently deaults to
size 8, which is hard to read so I always manually change
it to 10. Any suggestions would be appreciated.

John

 

[Debra Dalgleish]

You can change the font size of new comments by changing the settings in
your Control Panel. (Instructions for Windows XP)

1. Right-click on the desktop, and choose Properties
2. On the Appearance tab, click Advanced.
3. From the Item dropdown, choose Tooltip
4. Choose a font Size, click OK, click OK

Note -- this will also affect your Tooltips formatting

Or, you can use a macro to insert a comment with a specific font and format:
'======================================
Sub CommentAddOrEditTNR()
'adds TimesNewRoman comment or positions
'cursor at end of existing comment text
Dim cmt As Comment
Set cmt = ActiveCell.Comment
If cmt Is Nothing Then
ActiveCell.AddComment text:=""
Set cmt = ActiveCell.Comment
With cmt.Shape.TextFrame.Characters.Font
.Name = "Times New Roman"
.Size = 11
.Bold = False
.ColorIndex = 0
End With
End If
SendKeys "%ie~"
End Sub
'===========================