inserting comments ?

[Guest]

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

 

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

Copy => paste special => comments