Hi
not possible with formulas. This would require an event proceure

"AB" wrote:

Hello,

Is there a way by which I can make the contents of a
comment box dynamic, i.e. based on the contents of one or
more cells in the spreadsheet?

My preference is for a worksheet function / formula rather
than a macro. If no such function exists then of course
I will settle for a macro.

Thanks for your help.

AB.