Range.Comment (Excel)

Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range.

Dim cmmComment As Comment
Set cmmComment = ActiveCell.Comment