Permanent Formatting of New Comments

[Jeff Smith]

How can one customize the dimension (the shape and size)
of a new comment to my preferences and not the default of
the program? I want each new comment to print a specific
font and be created with a specific dimension that is
different then the default. The help file tells me how to
change the background colors or the name of the person
creating the comment, etc., but not how to "lock-in" the
specific dimension of the comment note I need within my
Excel worksheet... please help, and thanks in advance.

 

[Debra Dalgleish]

You can use a macro to insert a comment with a specific font and size.
For example:

'===============
Sub CommentAddSize()
'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
With .TextFrame.Characters.Font
.Name = "Times New Roman"
.Size = 11
.Bold = False
.ColorIndex = 0
End With
.Width = 100
.Height = 75
End With
End If
SendKeys "%ie~"
End Sub
'=========================