How to set comment font size and color in VBA

[ssunchen]

Hi,

I used record to generate a VBA Macro to set the comment font size and color. When the Macro was generated, nothing shows up in Macro.

Could you help me to generate a code in VBA to set the comment font size and color?

Thank you very much.

ssunchen

[Damon Ostrander]

Hi ssunchen,

Here is a sample macro that sets the font size, color and name of all comments residing in the selected cell or cells.

Sub SetCommentsProperties()
Dim Cell As Range
For Each Cell In Selection
If Not Cell.Comment Is Nothing Then
With Cell.Comment.Shape.TextFrame.Characters.Font
.ColorIndex = 3
.Size = 12
.Name = "Arial Black"
End With
End If
Next Cell
End Sub