obtain cell comments from another cell

[ying]

What I have now is a function that returns a value to the cell. I would like to add a comment from another cell in the workbook based on the value of the current cell. Is this possible to do? Is there something like an .AddComment sort of thing to use in the function?

Thanks!

Best, Ying

 

[DonkeyOte]

Do you perhaps mean for something like:

Function GetInfo(rngT As Range)
    GetInfo = rngT.Value
    With Application.Caller
        On Error Resume Next
        .Comment.Delete
        .AddComment rngT.Comment.Text
        On Error GoTo 0
    End With
End Function

called from a cell along the lines of:

=GETINFO(A1)

and the above cell would then populate based on A1's value with comment (if exists)

 

[ying]

Dear Mr. DonkeyOte, Thanks for your suggestions! Let me give it a try. I am not very skilled at this. So please bear with me.

Best, Ying

 

[ying]

Dear Mr. DonkeyOte, is it also possible to populate the cell with value including comment and formatting?

Thanks so much for your help!

Best, Ying

 

[DonkeyOte]

and formatting?

Not with a Function. The fact you are even able to copy Comments is slightly odd (IMO).

 

[ying]

Dear Mr. DonkeyOte, say I have a number in my cell which is 12, now I want to populate this cell with the value in cell B12, including comment and formatting. How can I do this?

Thanks a million!

Best, Ying

 

[ying]

I see not with formatting. But yes, I am happy that I can copy the comment at all. Is there some other way to copy a block of cells including comments and formatting without doing it manually? Is there a sub routine or something that can perform this?

Thanks again!

Best, Ying

 

[DonkeyOte]

You would need to use a Change Event (or equivalent - ie a general Sub Routine which is invoked re: constant as opposed to an in-cell Function)

IMO this is in effect a new question and to that end I'd ask you start a new thread as I'm afraid I don't have the time to work on the above.
A new thread will increase your chances of getting new input.

 

[ying]

Let me clarify. When I have an integer number, now I want to get the value from another cell based on the integer number in this cell. E.g. an integer number 12, based on that, I want to get value from cell B12. I hope I am clear.

Thanks!

Best, ying