Hi,
I need to check whether a comment is available in my active cell. If it is already exist in the active cell then I need to add a string to the exisiting comment. Otherwise need to add a new comment.
This is what i want:
If ActiveCell does not have a Comment
ActiveCell.AddComment
ActiveCell.Comment.Visible = False
ActiveCell.Comment.Text Text:="Extra minutes added " & Chr(10) & WB_VLength & ""
Else
ActiveCell.Comment.Text Text:=ActiveCell.Comment.Text & Chr(10) & "Extra minutes added " & Chr(10) & WB_VLength & ""
End If
Does anyone know how to do it?
Thank you very much for u r help!
Sanjna...
I need to check whether a comment is available in my active cell. If it is already exist in the active cell then I need to add a string to the exisiting comment. Otherwise need to add a new comment.
This is what i want:
If ActiveCell does not have a Comment
ActiveCell.AddComment
ActiveCell.Comment.Visible = False
ActiveCell.Comment.Text Text:="Extra minutes added " & Chr(10) & WB_VLength & ""
Else
ActiveCell.Comment.Text Text:=ActiveCell.Comment.Text & Chr(10) & "Extra minutes added " & Chr(10) & WB_VLength & ""
End If
Does anyone know how to do it?
Thank you very much for u r help!
Sanjna...