displaying a comment only when the cell is selected
 

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

Hi!

Use Data Validation.

Select the cell
Goto DataValidation
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" wrote in message
...
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

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


"Biff" wrote in message
...
Hi!

Use Data Validation.

Select the cell
Goto DataValidation
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" wrote in message
...
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