>I'm not folowing why yu would want to add the current date to the comments already there. So, I am assuming that you want people to put comments in the cells and that when they do, it also puts the current date in the cell as well.
>
>If so, yes you can do that. However, you would not do it by inserting a comment. You would do it by having the user run a macro. The macro could open a dialog box asking them to type their comment, then have the macro add that comment along with the date as a comment in the cell.
>
>If that isn't what you're talking about, let me know.
>
>
>>I have comments associated with cells. I would like the current date to show inside the comment area. Can this be done?

I have comments and I want to insert a variable, in this particular case, the current date, into the comment. When you hover over the cell, I need it to show whatever text was previously entered, and the current date in the text. Like putting a variable into a Word merge document. "Today is =Now()." I have a feeling it can't be done.

Does anyone know where the comments are stored? Is there a way to extract the text from multiple comments given the cell range? I'm talking about "comments" specifically, not the value in the cells.