formating comments

  • Thread starter Thread starter RustyMoran
  • Start date Start date
You can change the font size and colour of new comments
(but not the font) 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
 
Much obliged. Thank you.

You can change the font size and colour of new comments
(but not the font) 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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change the comment default format to include date? 4
comment format 2
how to change multiple cell comment properties? 1
default format for comment boxes 2
Default Comment Format 1
how to Permanently change default font for comments 2
Default format of cell comments 4
formatting comment's background color 1

Back
Top