Copying of cell text from one file to paste as cell comments in a 2nd file

[Wayne]

I would like to get the text in a cell in one file and
paste that text as comments to a second cell in another
file. Have tried a number of things but no luck!!

Wayne

 

[Guest]

Try this:

Say you want the data from workbook A into workbook B--
Open B. Turn on the vba recorder
Open A. Select the cell where your desired text is. In the formula bar
select the text you want, click Ctrl+C to copy.
Activate B. Select the cell where you want the comment.
Insert>comment>Ctrl+V to paste the text.
Stop the recorder and study the code. Adjust as needed.

 

[Guest]

Try

Sub CreateComm()

Dim commText As String

commText = ActiveCell.Value
With Range("A10") 'change as required
.AddComment
.Comment.Visible = False
.Comment.Text Text:="" & commText
End With

End Sub

Regards
Rowan

 

[Tom Ogilvy]

You received an answer to your question back in the original post.

Why put such vague information here - there is much more to your story than
what you have said. the more you tell, the more likely you will get a
focused answer. Although I admit you have changed it from copy a comment
to a comment to now copying text in a cell to a comment if that is what you
want to do.

 

[Wayne]

youmay be right, I haven't posted enough of the exact
situation. I wrote it all down but the post window closed
on me and I don't know if it posted so here goes again..

I Have a Master spreadsheet to track status of budgets
and projects. There are 7 columns for each of 7 managers.
Each column has cells with simple red, yellow and
green "stoplights". These are paste linked from each of
the managers individual status spreadsheets.

Each manager also has a Notes cell for each project right
by the stoplights (columns k and l). Rather than make 7
columns in the master sheet for these notes, i was tryong
to figure out how to copy the text from the Notes cells
in each subsidiary sheet and paste them as comments into
the appropriate stoplight cell.

Hope this is clearer!

Wayne