Here is what I am trying to achieve:

I have a large table whose cells either include much information or nothing
at all. Naturally, I don't want to display all the information in the table
because it gets too large. I want to mark all the cells having information
in them with an "R". As I click on any cell with an "R", the full content of
the cell is displayed in a large area on the top right on my spreadsheet. I
want every active "R" cell, to display its content in the same top right area.

How do I set this up?

Hi Louis,

Debra Dalgleish has a downloadable spreadsheet which demonstrates a method
of using a spreadsheet cell area to display comment text. See the 'Display
Comment Text' section at:

http://www.contextures.com/excelfiles.html#Comments


---
Regards,
Norman



"Louis Charland" <Louis wrote in message
...
Here is what I am trying to achieve:

I have a large table whose cells either include much information or
nothing
at all. Naturally, I don't want to display all the information in the
table
because it gets too large. I want to mark all the cells having
information
in them with an "R". As I click on any cell with an "R", the full content
of
the cell is displayed in a large area on the top right on my spreadsheet.
I
want every active "R" cell, to display its content in the same top right
area.

How do I set this up?

Hi Louis,

I should add that if you are not familiar with macros, you may wish to visit
David McRitchie's 'Getting Started With Macros And User Defined Functions'
at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman

Thank you Norman,

What if I do not want to use codes. Instead, I want every "R" cell to
display a different content, i.e. an independant comment for each. Is that
possible?

Thanks

"Norman Jones" wrote:

Hi Louis,

I should add that if you are not familiar with macros, you may wish to visit
David McRitchie's 'Getting Started With Macros And User Defined Functions'
at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman

Hi Louis,

What if I do not want to use codes. Instead, I want every "R" cell to
display a different content, i.e. an independant comment for each. Is that
possible?

The codes are intended to provide a means to link a cell to its comment,
which is held on a separate worksheet. Without the code, how will the
appropriate comment be displayed. It would be feasible to use the cell's
address as the key, but, clearly, this would fail if rows or columns were
inserted in the main sheet.

Therefore, rather than using a simple 'R', try using R1, R2...Rn to
designate your comment cells. If you wish your users only to see the 'R',
why not set the font colour of the appended numeric to match the colour of
the cell background?


---
Regards,
Norman