Linking formulas to comments in cells

[james peter bruce]

Hi,

Does anyone know if the following is possible.

I pull in data from an application which gives me a list of "numbers for runs" each number for the run is assigned a data but only in the comment cells. The application we have is fixed in that way.

Does anyone know if you can pull in a forumla or function to for example
= comment(A1)
so that will show the comment in cell A1

Does such a thing exsit ?

Thanks

James Bruce

 

[Richie(UK)]

Hi James,

Welcome to the board :D

I'm not aware of a built-in function that will do what you wish, but you could always write your own UDF. What about:

Function SComment(rng As Range) As String
    SComment = rng.Comment.Text
End Function

And then use like this:
=SComment(A1)
to display the comment text contained in A1.

HTH