Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Copy comment (2003)

    Hi All,

    I saw <post#=457477>post 457477</post#> about creating a comment to apply to the multiple cells in a selection. I'm looking for something slightly different - the ability to take an existing comment and copy it to another cell (text, comment box properties and all). While I might be able to make do with the macro in the post, it requires me to know ahead of time which cells will get the comment and I don't always know that up front. It seems like some way to select the existing commented cell (with a msg if that cell isn't commented) and to select the cells to get a copy of the comment is needed. Opening the comment dialog to edit an existing comment, copying the text, doing the same for a new comment, pasting the existing comment text into the new comment box, and resizing the new comment box is too much work for this - hoping there's a way to automate this.

    TIA.

    Fred

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy comment (2003)

    1. Copy the cell with the comment to the clipboard
    2. Select the cell or cells you want to copy the comment to. (You can select non-contiguous ranges using Ctrl)
    3. Select Edit | Paste Special...
    4. Click the Comments option button.
    5. Click OK.

    You can combine steps 3-5 in a macro:

    Sub PasteComments()
    On Error Resume Next
    Selection.PasteSpecial xlPasteComments
    End Sub

    and assign it to a toolbar button.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Copy comment (2003)

    Hans,

    Excellent. I need to look more carefully at the Paste Special capabilities since I'm still operating in the dark ages. I don't recall all of those options being available in earlier versions of Excel.

    Fred

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Copy comment (2003)

    Copying comments was available in XL97

    Steve

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Copy comment (2003)

    Hi Steve,

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> In my defense, I never had the need before last Sept to do this so probably never noticed. I do see that there are certainly more paste special options available in 2003. I use comments to indicate in a teacher grading spreadsheet that a student came in late on test day. This is done next to his/her score so that I know if a low score is perhaps due to being late. If several students come in late, I want to copy the comment to each such student (maybe editing it to indicate the time). I use similar/identical comments for multiple students for other reasons also.

    Fred

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Copy comment (2003)

    If you are going to copy the comment, it may be faster to copy the entire cell and just paste the contents (this will include the comment and value) afterwards you can just edit the contents if desired.

    This may be faster since it is a ctrl-c / ctrl-v rather than using a toolbar...

    Steve

  7. #7
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Copy comment (2003)

    True. Usually there will be a little edit of the comment. For example one student comes in at 8:10 (class starts at 8) on test day while another comes in at 8:20; so the comment for the first student will be something like "came in at 8:10AM". Since the contents are just the test score, editing the content is not a big deal but I still need to edit the comment.

    Fred

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •