Forum Discussion

Copper Contributor

Jan 06, 2020

Extracting content from all cell notes on Excel sheet

I have used an Excel Sheet to record blood pressure readings for my health, and I have put a daily journal remark in a separate cell note for each day. I have hundreds of these notes, and I am trying...

Iron Contributor

Jan 06, 2020

You can use the example custom function found at https://professor-excel.com/excel-extract-comments-text-to-cell/.

Function ReturnNoteText(cell As Range)
    ReturnNoteText = cell.Comment.Text
End Function

use as:

EloyMendoza
Copper Contributor
Aug 25, 2021
Hi Chris, this function worked fine for me but when note changes my formula does not refreshes, do you know why?
Thanks in advance
- ChrisMendoza
  Iron Contributor
  Aug 25, 2021
  EloyMendoza- it looks like https://professor-excel.com/excel-extract-comments-text-to-cell/ was updated for threaded comments. I have this version of Excel now so I can't test on an older version. My guess however is that you'll need to refresh the formula manually (enter edit mode and then enter; or similar manually) or I suppose you could do some VBA on cell change to refresh the calculation.
  - EloyMendoza
    Copper Contributor
    Aug 25, 2021
    Chris, Thanks for your quick answer.
Noel_Sherry
Copper Contributor
Jan 07, 2020
ChrisMendoza
Thanks, Chris, I see that code.
I am a novice. I do not know how to create a macro, how to record it, save it, debug it, and then run it to do what it is supposed to do. Maybe this is just beyond me.
But thanks,
Noel
- ChrisMendoza
  Iron Contributor
  Jan 07, 2020
  Noel_Sherry -
  Learning more about Excel is not beyond anyone. https://support.office.com/en-us/article/create-custom-functions-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f provides you a good start.
  - Noel_Sherry
    Copper Contributor
    Jan 07, 2020
    ChrisMendoza
    Thanks, Chris, I will start there.
    
    Noel

Resources