Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get data from comment
Im really new to using excel and one thing I canīt figure out with the help guide is how to get the data in a comment to a cell. A1_comment - A2 The data (in my case text) to show in another cell. Thanks in advance! -- mooler ------------------------------------------------------------------------ mooler's Profile: http://www.excelforum.com/member.php...fo&userid=8670 View this thread: http://www.excelforum.com/showthread...hreadid=361273 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get data from comment
You need to insert the following VBA custom function into a module in your
workbook. Function CELLCOMMENT(ByVal range_input As Range) CELLCOMMENT = range_input.Comment.Text End Function Then, in cell A2, you type: =CELLCOMMENT(A1) A2 will return the cell comment in cell A1. Regards, Edwin Tam http://www.vonixx.com "mooler" wrote: Im really new to using excel and one thing I canÂīt figure out with the help guide is how to get the data in a comment to a cell. A1_comment - A2 The data (in my case text) to show in another cell. Thanks in advance! -- mooler ------------------------------------------------------------------------ mooler's Profile: http://www.excelforum.com/member.php...fo&userid=8670 View this thread: http://www.excelforum.com/showthread...hreadid=361273 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get data from comment
{cell of interest}.Comment.Text gives you the comment.
{cell of interest}.Value lets you change the value of a cell. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Im really new to using excel and one thing I can=3Ft figure out with the help guide is how to get the data in a comment to a cell. A1_comment - A2 The data (in my case text) to show in another cell. Thanks in advance! -- mooler ------------------------------------------------------------------------ mooler's Profile: http://www.excelforum.com/member.php...fo&userid=8670 View this thread: http://www.excelforum.com/showthread...hreadid=361273 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
Comment instead of Data Validation | Excel Discussion (Misc queries) | |||
ADD DATA TO A COMMENT BOX | Excel Discussion (Misc queries) | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
Need to Pull Data into a Comment | Excel Programming |