Forum Discussion
Excel Cell Comments/Notes in VBA
I am trying to retrieve Note/Comment Cell text using VBA. I have no problem getting the text for a cell note but I have not found a way to get the text for a cell comment. Example code. str = Works...
Hi!
Add "Threaded" to "Comment"
old:
str = Worksheets(1).Range("A1").Comment.Text
new:
str = Worksheets(1).Range("A1").CommentThreaded.Text
Hope this helps
DataVision
DataVisionadding the "threaded" did work but it only grabs the first comment. Any suggestions when cells have multiple comments in them?