Using cell comment in formula

[ccordner]

Is it possible to use information from a cell comment in a formula? I suspect the answer is no, but I'm trying to avoid using a 'hidden' row if possible.

Thanks
Chris

 

[tweedle]

Not natively, you'd need a UDF to look into the comment.

 

[Jaye7]

You could have the comment export to a cell upon right click etc... and then use the information from the cell.

 

[tweedle]

like this

'In a Module
Public Function UDFGetCommentFromCell(cell As Range)
    Dim commnt As comment
    Set commnt = cell.comment
    If Not commnt Is Nothing Then
        UDFGetCommentFromCell = commnt.Text
    Else
        UDFGetCommentFromCell = "N/A"
    End If
    
End Function