displaying a comment only when the cell is selected

[Jeff]

I'd like to insert a comment in a certain cell, so that when that cell is
selected by a user, the comment is then displayed. I know this must be
possible, but I haven't been able to figure it out....

I can show or hide comments in various combinations, but can't find a way to
hide the comment UNTIL the cell is selected, and then display it. How do I
do this please?!
Thanks

 

[Biff]

Hi!

Use Data Validation.

Select the cell
Goto Data>Validation
Select the Input message tab
Type in your message
OK out

The message will only be displayed when that cell is selected. (no mouse
over like a normal cell comment)

There is a limit as to the length of the message but I can't recall what
that limit is, maybe 255 chars. ???

Biff

 

[Jeff]

Thanks Biff, that's exactly what I wanted!
Jeff

Hi!

Use Data Validation.

Select the cell
Goto Data>Validation
Select the Input message tab
Type in your message
OK out

The message will only be displayed when that cell is selected. (no mouse
over like a normal cell comment)

There is a limit as to the length of the message but I can't recall what
that limit is, maybe 255 chars. ???

Biff