Comments

[felix]

Is it possible to copy a value in a cell and add it as a
comment? How would such a macro look like? Preferably the
comment box should be resized to just reveal the short
entry.
Thank you

 

[David McRitchie]

Hi Felix,
See my page
http://www.mvps.org/dmcritchie/excel/ccomment.htm

 

[Guest]

Hi Ritchie,
thx for your prompt reply.

Amazing what can be done with a Comment Box, but
unfortunately I coudn't find (or am too stupid to find)
how to copy a value from a cell (in my case the same one)
into a comment box.

I will study your site carefully, I'm sure there are a lot
of hints.

Felix

 

[Guest]

Hi Ritchie,
thx for your prompt reply.

Amazing what can be done with a Comment Box, but
unfortunately I coudn't find (or am too stupid to find)
how to copy a value from a cell (in my case the same one)
into a comment box.

I will study your site carefully, I'm sure there are a lot
of hints.

Felix

 

[David McRitchie]

Hi Felix,
Placing Formulas into Cell Comments (#ccformulas)
http://www.mvps.org/dmcritchie/excel/ccomment.htm

Adding / Changing Cell Comments (#change)
Placing Displayed Text into Cell Comments (#cctext)

If you can be more specific about exactly what and
when you want it to happen, I could be more specific
of where to look.

Most work on a selection. Some are event macros to
change value when you change the value by typing in
a new value into a cell.

If not familiar with macros you might want to look over
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.mvps.org/dmcritchie/excel/proper.htm for usage

http://www.mvps.org/dmcritchie/excel/event.htm
has usage examples