software

I'm trying to inert comments into a spreadsheet. Sometimes I need to
duplicate what is in one comment box into another. Is there a way to copy
and paste when inserting comments?

Excel 2003 is the version I am using

Thanks
Jeannette

that does not work ... once you click on Insert Comment and the box pops up
there is not option for paste or paste special. Does it need to be done
before click insert comment?

Jeannettequot;ewan7279quot; wrote:

gt; Copy =gt; paste special =gt; comments
gt;
gt; quot;sunrosejennquot; wrote:
gt;
gt; gt; I'm trying to inert comments into a spreadsheet. Sometimes I need to
gt; gt; duplicate what is in one comment box into another. Is there a way to copy
gt; gt; and paste when inserting comments?
gt; gt;
gt; gt; Excel 2003 is the version I am using
gt; gt;
gt; gt; Thanks
gt; gt; Jeannette

I have a button on a toobar that pastes the comments in using this code

Private Sub PasteComments()

Selection.PasteSpecial Paste:=xlPasteComments, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
End Sub--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;sunrosejennquot; gt; wrote in message
...
gt; I'm trying to inert comments into a spreadsheet. Sometimes I need to
gt; duplicate what is in one comment box into another. Is there a way to copy
gt; and paste when inserting comments?
gt;
gt; Excel 2003 is the version I am using
gt;
gt; Thanks
gt; Jeannette
Right-click on the cell that has the comment box you wish to duplicate, then
select COPY from the drop down.........then Right-click on the cell you wish
to replicate the comment in and select PASTE SPECIAL, then select COMMENTS,
then OK then Left-click off to any other cell........

hth
Vaya con Dios,
Chuck, CABGx3
quot;sunrosejennquot; wrote:

gt; I'm trying to inert comments into a spreadsheet. Sometimes I need to
gt; duplicate what is in one comment box into another. Is there a way to copy
gt; and paste when inserting comments?
gt;
gt; Excel 2003 is the version I am using
gt;
gt; Thanks
gt; Jeannette

This only works to copy the entire comment box from one cell to another.

Within comment boxes, you can copy and paste by clicking the right mouse
button (or using ctrl C and ctrl V).

e.g. right click =gt; insert comment. Type the desired text, highlight it,
right click, copy. Select the comment box you wish to add the text to, right
click =gt; edit comment, select the area of the comment box that you would like
to paste the copied comment, right click =gt; paste.

quot;sunrosejennquot; wrote:

gt; that does not work ... once you click on Insert Comment and the box pops up
gt; there is not option for paste or paste special. Does it need to be done
gt; before click insert comment?
gt;
gt; Jeannette
gt;
gt;
gt; quot;ewan7279quot; wrote:
gt;
gt; gt; Copy =gt; paste special =gt; comments
gt; gt;
gt; gt; quot;sunrosejennquot; wrote:
gt; gt;
gt; gt; gt; I'm trying to inert comments into a spreadsheet. Sometimes I need to
gt; gt; gt; duplicate what is in one comment box into another. Is there a way to copy
gt; gt; gt; and paste when inserting comments?
gt; gt; gt;
gt; gt; gt; Excel 2003 is the version I am using
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt; Jeannette

Copy =gt; paste special =gt; comments

quot;sunrosejennquot; wrote:

gt; I'm trying to inert comments into a spreadsheet. Sometimes I need to
gt; duplicate what is in one comment box into another. Is there a way to copy
gt; and paste when inserting comments?
gt;
gt; Excel 2003 is the version I am using
gt;
gt; Thanks
gt; Jeannette