There's sample code here to insert a comment:

http://www.contextures.com/xlcomments03.html#Plain

You could use something similar on the worksheet's
Worksheet_BeforeDoubleClick event.

To extract the cell comments and text, use code similar to the code he

http://www.contextures.com/xlcomment...ml#CopyToSheet


Brad wrote:
Hello,

I have created a sales tracking sheet and would like the reps to utitilize
the Comments on each cell. What I would like to do if possible, is to have
them double click on a cell with in Column E(E1:E30) and it would pop up a
message box allowing the rep to add comments about the deal.

2nd request would be to extract to extract these comments along with the
data that is populated in the cell. In my instance it would be the quote #
and the comments that are in that cell.

Is this possible? Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html