Change Color of Cell Comment Indicator

[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.

 

[pfsardella]

Browse through this.

http://www.google.com/groups?as_epq...F-8&as_ugroup=*excel*&lr=lang_en&num=50&hl=en

HTH
Paul

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

Disregard - I thought you meant the background color - somehow I missed the
Indicator part.