View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Reference a specific cell in the active row

I had an afterthought on this and wondered if you might appreciate a little
more information if you need to delete the comment or edit the info in an
existing comment. (You can't add a comment if one already exists.)

Private Sub Worksheet_Change(ByVal Target As Range)

With Target

If .Value < Cells(Target.Row, "B").Value Then
If .Comment Is Nothing Then
.AddComment
End If

.Comment.Text Text:=Application.UserName & ":" & Chr(10)
.Comment.Visible = True
Else
If Not .Comment Is Nothing Then
.Comment.Delete
End If
End If

End With

End Sub

--
Regards,

OssieMac