If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying comments from one cell to another, in a different spreadsheet
Hello Friends,
I would like to be able to write a comment in a cell, then have that comment appear in another cell on a different spreadsheet within the same workbook, though. Or within the same spreadsheet. Is there a formula or some sort of formatting to allow for the type of function? Thanks in advance!! |
#2
|
|||
|
|||
Copying comments from one cell to another, in a different spreadsheet
I'm not sure if it can be done without code. Insert this in a new
module in "Personal.xls" in the VBA editor. Let me know if you need further explanation or if you want to tie it directly to your workbook. Function Comments(iRange As Range) As String If iRange.Comment Is Nothing Then Comments = "NA" Else Comments = iRange.Comment.Text End If End Function then in your spreadsheet type =Comments(A1) HTH Die_Another_Day =!CmOrE!= wrote: Hello Friends, I would like to be able to write a comment in a cell, then have that comment appear in another cell on a different spreadsheet within the same workbook, though. Or within the same spreadsheet. Is there a formula or some sort of formatting to allow for the type of function? Thanks in advance!! |
#3
|
|||
|
|||
Copying comments from one cell to another, in a different spreadsheet
you can use "copy" on cell with comment and "Edit"-"Paste Special"-"Comment"
on cell which should receive comment. "=!CmOrE!=" wrote in message oups.com... Hello Friends, I would like to be able to write a comment in a cell, then have that comment appear in another cell on a different spreadsheet within the same workbook, though. Or within the same spreadsheet. Is there a formula or some sort of formatting to allow for the type of function? Thanks in advance!! |
#4
|
|||
|
|||
Copying comments from one cell to another, in a different spreadsheet
Couldn't do it. Can you explain further.
Thank you Die_Another_Day wrote: I'm not sure if it can be done without code. Insert this in a new module in "Personal.xls" in the VBA editor. Let me know if you need further explanation or if you want to tie it directly to your workbook. Function Comments(iRange As Range) As String If iRange.Comment Is Nothing Then Comments = "NA" Else Comments = iRange.Comment.Text End If End Function then in your spreadsheet type =Comments(A1) HTH Die_Another_Day =!CmOrE!= wrote: Hello Friends, I would like to be able to write a comment in a cell, then have that comment appear in another cell on a different spreadsheet within the same workbook, though. Or within the same spreadsheet. Is there a formula or some sort of formatting to allow for the type of function? Thanks in advance!! |
#5
|
|||
|
|||
Copying comments from one cell to another, in a different spreadsheet
To make the code stay with your workbook.
Open the workbook. Press Alt+F11 Click the Insert menu Click Module Copy the following code into the page that opens Function Comments(iRange As Range) As String If iRange.Comment Is Nothing Then Comments = "NA" Else Comments = iRange.Comment.Text End If End Function That should do it Die_Another_Day =!CmOrE!= wrote: Couldn't do it. Can you explain further. Thank you Die_Another_Day wrote: I'm not sure if it can be done without code. Insert this in a new module in "Personal.xls" in the VBA editor. Let me know if you need further explanation or if you want to tie it directly to your workbook. Function Comments(iRange As Range) As String If iRange.Comment Is Nothing Then Comments = "NA" Else Comments = iRange.Comment.Text End If End Function then in your spreadsheet type =Comments(A1) HTH Die_Another_Day =!CmOrE!= wrote: Hello Friends, I would like to be able to write a comment in a cell, then have that comment appear in another cell on a different spreadsheet within the same workbook, though. Or within the same spreadsheet. Is there a formula or some sort of formatting to allow for the type of function? Thanks in advance!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom functions calculating time arguments Help Desperate | Bill_De | Worksheet Functions | 12 | April 25th, 2006 02:22 AM |
Returning Cell Comments from One Cell to Another | RJS | Worksheet Functions | 3 | March 13th, 2006 11:39 PM |
AUTOMATIC way to copy the value of a cell in one spreadsheet | Mihalis4 | Worksheet Functions | 2 | December 2nd, 2005 06:49 PM |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |