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