View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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,