Can I add cell info into a comment box via a formula?

[Maxmah]

Hello,
I want info that is contained in a cell (i.e "PO# 57892") to a comment box that is flagged in another cell, is that even possible? I know i can go into the cell, and select "Insert comment". but I'd like the cell info to got directly to the comment box and save the steps.

[snb]

You can't do this using an Excel Formula.
In VBA it is possible.

Assume:
B3 has a comment
In this comment the value in A12 should be showed.


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$12" Then Cells(3, 2).Comment.Text Target.Text
End Sub