I know that you can have TextBox objects in Excel which have
a .DrawingObject.Formula property that you can set programmatically
(or in the GUI) so that whenever you calculate the sheet, if the
underlying cell changes the textbox's text will also change.

Is this possible to do with Excel Comments? I have already tried to
Comment.Shape.DrawingObject.Formula, but it errors out, saying that
you cannot access that property. Is there any way to make the text of
a comment dynamically refer to the contents of a cell?