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

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

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