Cell content as a comment for another cell
 

Hi,
I need a tool that allow me to show a cell content into a comment for
another cell.

Thanks in advance.

AMK

Cell content as a comment for another cell
 

Insert a new module into the workbook (Alt + F11) and pase this code in

Function GetComment(rCommentCell As Range)
Dim thecomment As String
On Error Resume Next
thecomment = WorksheetFunction.Clean _
(rCommentCell.Comment.Text)
GetComment = thecomment
On Error GoTo 0
End Function

Put this in a cell

=GetComment(A1)

If A1 contains a comment it will be returned



"AshMorK" wrote:

Hi,
I need a tool that allow me to show a cell content into a comment for
another cell.

Thanks in advance.

AMK

Cell content as a comment for another cell
 

thanks Mike for your help, but what i need is something different. For example:

cell A1= "the coment i want to insert"
cell B1= Any caracter

What i want, is to insert a comment in cell B1 showing the text in cell A1
(Comment = "the coment i want to insert")

Thanks again,

"Mike" wrote:

Insert a new module into the workbook (Alt + F11) and pase this code in

Function GetComment(rCommentCell As Range)
Dim thecomment As String
On Error Resume Next
thecomment = WorksheetFunction.Clean _
(rCommentCell.Comment.Text)
GetComment = thecomment
On Error GoTo 0
End Function

Put this in a cell

=GetComment(A1)

If A1 contains a comment it will be returned



"AshMorK" wrote:

Hi,
I need a tool that allow me to show a cell content into a comment for
another cell.

Thanks in advance.

AMK