Hi

take a look at Debra Dalgleish's site
http://www.contextures.com/xlcomments03.html#CopyToWord

If you scroll down the sheet, there is also code from Dave Peterson to copy
comments to another sheet in the workbook.

--
Regards
Roger Govier

"Mr BT" wrote in message
news:%PDak.50742$Jx.7958@pd7urf1no...
Hi
Is there a way, formulae or vb, to copy the text from a comment (or many)
to a selected cell?
Thank you for the assistance