excelvba

How do I retrieve the text of a cell comment

I find lots of examples for creating but none for retrieving the text of a cell comment. Am I missing something obvious?

Solution

  • Range.Comment.Text seems to work without any problem here...

    (e. g. if not ActiveCell.Comment is nothing then debug.print ActiveCell.Comment.Text)