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?

Jeannette


"ewan7279" wrote:

Copy = paste special = comments

"sunrosejenn" wrote:

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

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)

"sunrosejenn" wrote in message
...
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

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



"sunrosejenn" wrote:

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

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 = insert comment. Type the desired text, highlight it,
right click, copy. Select the comment box you wish to add the text to, right
click = edit comment, select the area of the comment box that you would like
to paste the copied comment, right click = paste.

"sunrosejenn" wrote:

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?

Jeannette


"ewan7279" wrote:

Copy = paste special = comments

"sunrosejenn" wrote:

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

Copy = paste special = comments

"sunrosejenn" wrote:

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