Get the comment text : Cell Comments « Excel « VBA / Excel / Access / Word

Get the comment text

     Function GetCommentText(rCommentCell As Range)
     Dim strGotIt As String
         On Error Resume Next
         strGotIt = WorksheetFunction.Clean _
         GetCommentText = strGotIt
         On Error GoTo 0
     End Function



Related examples in the same category

1.Converts docstring column into comments on name column.
2.Tracking cell changes in a comment
3.Clean the comment
4.resize Comments
5.Count Comments
6.Toggle Comments