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 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" <no_em@ilplea.se> wrote in message
news:JdidneQOi7emGVbfRVnyhg@eclipse.net.uk...
> 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" <biffinpitt@comcast.net> wrote in message
news:eF0E$xfgFHA.2180@TK2MSFTNGP15.phx.gbl...
> 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" <no_em@ilplea.se> wrote in message
> news:JdidneQOi7emGVbfRVnyhg@eclipse.net.uk...
>> 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
>>
>
>