Hi tech_ed and welcome to the forum,
Put this code behind your sheet where the comments are. Then double click a cell that has a comment in it and see if you can use the Windows Clipboard to paste it somewhere.
Option Explicit
'Copy comment behind Double Clicked Cell into Clipboard.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error Resume Next
Range("AA100").Value = "" 'Using a non-used range at AA100
Range("AA100").Value = Range(Target.Address).Comment.Text
On Error GoTo 0
Range("AA100").Copy
Cancel = True
End Sub
Bookmarks