Create a Comment in a cell via a Worksheet function (not using macros)?

[Android]

Hi,

I am using the VLOOKUP function to populate a sheetX with data from another
sheetY in the same workbook.

Is it possible to take the text in a cell in sheetY and add it as a
"comment" for a cell in SheetX, using a workwheet function.

I know this can be dome via VBA, but i prefer to use a worksheet function if
possible.

Is this possible?

Android.

 

[Frank Kabel]

Hi
AFAIK not possible with formulas

 

[Android]

OK, but what is AFAIK?

Just curious.

Android.

Hi
AFAIK not possible with formulas

 

[Harlan Grove]

OK, but what is AFAIK?

Just curious.

...

http://info.astrian.net/jargon/terms/a/AFAIK.html

 

[Guest]

Harlan,
Thanks,
Great link, right on the money (as ever)

 

[Dave Peterson]

you could have a UDF (user defined function) to copy a comment from one cell to
another. It'll be written in VBA, but it can be called from a worksheet cell.

Option Explicit
Function EchoComment(FCell As Range, TCell As Range)

If TCell.Comment Is Nothing Then
'do nothing
Else
TCell.Comment.Delete
End If

If FCell.Value = "" Then
'do nothing
Else
TCell.AddComment Text:=FCell.Value
End If
EchoComment = ""

End Function

Then I could put this in any cell:
=echocomment(sheety!a1,sheetz!b3)

in any old cell.