displaying a comment only when the cell is selected

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
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
 
Thanks Biff, that's exactly what I wanted!
Jeff


Biff said:
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
Click to expand...
 
Back
Top