Functions in Excel Comments

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.
 
B

Bernard Liengme

Comment hold text, and only text
You could copy a cell's formula from the formula bar and paste into a
comment
best wishes
 
C

Chevron7

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import Comments 3
Extract comments? 2
Mouseover Textbox for Changing Cells 13
Text Color Functions 1
Excel VBA 1
comments in a cell 6
Excel Excel 2007 Copy Comments to Cells 0
Custom print comments in Excel 2007 1

Top