Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mancitmis
 
Posts: n/a
Default 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

  #2   Report Post  
 
Posts: n/a
Default 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.

  #3   Report Post  
mancitmis
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding numbers in one cell and showing total in seperate cell Deernad Construction Excel Discussion (Misc queries) 12 November 29th 05 07:32 PM
How to set cell to a comment from another cell? Pete at Sappi Fine Paper Excel Discussion (Misc queries) 2 September 21st 05 06:51 PM
displaying a comment only when the cell is selected Jeff Excel Discussion (Misc queries) 2 July 6th 05 09:21 AM
Cell comment boxes shouldn't change size/shape unless changed by u sam Excel Discussion (Misc queries) 1 March 3rd 05 05:23 PM
Adding a prefix to a cell by using a formula Audrey in OHIO Excel Discussion (Misc queries) 4 February 24th 05 04:49 PM


All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"