Hi Jignesh, works great for comments but not so much for the new 365 office version. Where comments are stored as Notes. Tried changing a bit of VBA to get to this but without result: Function CellComments(xCell As Range) As String On Error Resume Next CellComments = xCell.NoteText.Text End Function
@ellim9540
Жыл бұрын
Thanks! It works great, but when the text in textbox change, it wont change unless you either retype the formula or copy the formula and paste it. Anyway to get around it? Is there a way to extract all notes in all textbox in a workbook?
@sripriyasureshkumar9126
3 жыл бұрын
I'm getting a blank cell when executed. How do I fix this?
@martinfaucher2194
2 жыл бұрын
I believe Excel 2019 changed the Comments to Notes. This code change fixed the issue for me: Function ExtractComment(xCell As Range) As String On Error Resume Next ExtractComment = xCell.NoteText End Function
Пікірлер: 4