Forum Discussion

Jan Auzins's avatar
Jan Auzins
Copper Contributor
Apr 05, 2019

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...
office 365
DataVision's avatar
DataVision
Copper Contributor
Sep 30, 2019

Jan Auzins 

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

 

  • Philip_Hinton's avatar
    Philip_Hinton
    Copper Contributor
    Oct 09, 2024
    "CommentThreaded" was the bit I needed, thanks!
  • INAVjordan's avatar
    INAVjordan
    Copper Contributor
    Jan 19, 2021

    DataVisionadding the "threaded" did work but it only grabs the first comment. Any suggestions when cells have multiple comments in them?

  • Jan Auzins's avatar
    Jan Auzins
    Copper Contributor
    Oct 01, 2019

    DataVision That's great, thank you.

Resources