Functions in Excel Comments

  • Thread starter Thread starter Chevron7
  • Start date Start date
C

Chevron7

Can functions or cell references be used in a Comment. I have text
descriptions defined in a series of cells and would like to display a
description from one of these cells when I hover over another corresponding
cell. I would rather not write a VBA fucntion to implement this functionality.
 
Comment hold text, and only text
You could copy a cell's formula from the formula bar and paste into a
comment
best wishes
 
Thanks. It's not the answer I was hoping for. I was hoping the formula could
somehow be interpreted and executed,i.e., extract text from a cell and
display it as the comment for another cell. But I guess it is what it is.
 
Back
Top