Copying Comments

[Paul Calcagno]

Can someone tell me if there's a command to copy a Comment that's been
created for a cell in Excel (Office 2007). I can create, edit and delete one
but don't see any tools for copying a comment.
Thanks, in advance.............Paul C.

 

[Dave Peterson]

In xl2003 menus, it shows up under the Edit|Paste special dialog.

I'd look there first (Home tab|Clipboard group????)

 

[Dave Peterson]

I looked at xl2007:

Home tab|Clipboard group|paste icon|paste special|comments.

Or rightclick on the destination cell and choose paste special|comments.

 

[Chris Bode]

Code
-------------------

Private Sub CommandButton1_Click()
'copy comment from A1 to B1
Sheet1.Range("B1").AddComment Sheet1.Range("A1").Comment.Text

End Sub

 

[Paul Calcagno]

Sorry for the delay in getting back, but when I click on the paste icon in
Home Tab|Clipboard group|paste icon, the paste special icon is greyed out.
Same thing happens if I rightclick on the destination cell... I cannot chose
the paste special|comments feature since it's greyed out also. I must be
doing something wrong.
If I'm attempting to paste special shouldn't I have proceeded that with a
copy. Buy copy what?
Paul C.

 

[Dave Peterson]

Yes, you have to copy something first to be able to paste it.

You'll want to select the cell with the comment, then do the copy (ctrl-c or
rightclick|copy).

Then do the paste special|comments

 

[Paul Calcagno]

Got it and it works fine. Thanks for the assistance...........Paul C.