Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying of cell text from one file to paste as cell comments in a 2nd file
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying of cell text from one file to paste as cell comments in a
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. InsertcommentCtrl+V to paste the text. Stop the recorder and study the code. Adjust as needed. "Wayne" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying of cell text from one file to paste as cell comments in a
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 "Wayne" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying of cell text from one file to paste as cell comments in a 2nd file
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. -- Regards, Tom Ogilvy "Wayne" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying of cell text from one file to paste as cell comments in a 2nd file
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Cell Comments and Paste as text in a cell | Excel Worksheet Functions | |||
Excel 2003 Cell Comments causes large file size? | Excel Discussion (Misc queries) | |||
I lose cell comments in Excel when moving a file via a USb drive | Excel Discussion (Misc queries) | |||
Paste file name into cell | Excel Discussion (Misc queries) | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) |