Comment Default Font Size

  • Thread starter Thread starter John M
  • Start date Start date
J

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
 
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
'===========================
 
Back
Top