Adding a comment to a cell
 

Hi,

New to here, just a quick question.

I know how to add a comment to a cell so that when the cursor moves
over it, it appears.

How do I produce a comment that appears only when the cell is clicked?

Apreciate your help.

Thanks in advance


--
mancitmis
------------------------------------------------------------------------
mancitmis's Profile: http://www.excelforum.com/member.php...o&userid=28495
View this thread: http://www.excelforum.com/showthread...hreadid=480987

Adding a comment to a cell
 

There's no 'real' way to do this, but one way would be to use the
'Input Message' feature of the Data Validation tool.

Go to DataValidation...Input Message tab and check 'Show Input message
when cell is selected'. Then type your message in the box provided.

Adding a comment to a cell
 

That's just what I was looking for.......Thank you!!


--
mancitmis
------------------------------------------------------------------------
mancitmis's Profile: http://www.excelforum.com/member.php...o&userid=28495
View this thread: http://www.excelforum.com/showthread...hreadid=480987