Comments

F

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
 
G

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



-----Original Message-----
Hi Felix,
See my page
http://www.mvps.org/dmcritchie/excel/ccomment.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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
Click to expand...


.
Click to expand...
 
G

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



-----Original Message-----
Hi Felix,
See my page
http://www.mvps.org/dmcritchie/excel/ccomment.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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
Click to expand...


.
Click to expand...
 
D

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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



-----Original Message-----
Hi Felix,
See my page
http://www.mvps.org/dmcritchie/excel/ccomment.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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
Click to expand...


.
Click to expand...
Click to expand...
 
Top