Removal of author from Comments
Only by parsing it out.
the whole think is just a single text string
Sub ae()
Dim rCell As Range
Dim sStr As String
Dim ipos As Long
Set rCell = Range("D6")
sStr = rCell.Comment.Text
ipos = InStr(1, sStr, ":", vbTextCompare)
sStr = Trim(Right(sStr, Len(sStr) - ipos))
MsgBox "You have comment which says " & sStr
End Sub
--
Regards,
Tom Ogilvy
"Jim May" wrote in message
news:X8M5f.2179$AO5.1064@dukeread01...
I currently have a line of code:
MsgBox "You have comment which says " & rCell.Comment.Text
which displays the FULL Comments area.
Can I EXCLUDE the AUTHOR text? If so,
How?
TIA,
|