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.

Browse through this.

http://www.google.com/groups?as_epq=...n&num=50&hl=en

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
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


--
Regards,
Tom Ogilvy

"Michael" wrote in message
...
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.

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

--
Regards,
Tom Ogilvy


Tom Ogilvy wrote in message
...
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


--
Regards,
Tom Ogilvy

"Michael" wrote in message
...
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.