Change Color of Cell Comment Indicator

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I would like to be able to change the color of the cell
comment indicator via programming (e.g. red, yellow, green
depending on severity of a particular comment). I see no
object reference to the color of the indicator nor have I
been able to come up with any workaround... any ideas out
there on how to do this?

I am very surprised that Excel would not give you the
ability to do this.
 
Sub ModifyComment()
With ActiveCell.Comment.Shape
.Fill.Visible = msoTrue
.Fill.Solid
.Fill.ForeColor.SchemeColor = 52
.Fill.Transparency = 0#
.Line.Weight = 0.75
.Line.DashStyle = msoLineSolid
.Line.Style = msoLineSingle
.Line.Transparency = 0#
.Line.Visible = msoTrue
.Line.ForeColor.RGB = RGB(0, 0, 0)
.Line.BackColor.RGB = RGB(255, 255, 255)
End With
End Sub
 
Disregard - I thought you meant the background color - somehow I missed the
Indicator part.
 
Back
Top