Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JB Christy
 
Posts: n/a
Default Comments Appearing When Cell Is Selected (Not Hovered Over)

I'm familiar with the comments that appear when your mouse hovers over a
cell. However, I noticed that in some of the templates that I downloaded
from Microsoft's site they had comments that appeared when the cell was
selected. So the comment always appeared when you tried to enter data in the
cell, regardless of how you selected the cell (arrow keys, tabbing, as well
as hover/mouse click).

Does anyone know how they did that? I can only do the "Insert Comment"
thing, and the comment only appears if they happen to move the mouse over
the cell.

a T d H v A a N n K c S e.

-JB


  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Comments Appearing When Cell Is Selected (Not Hovered Over)

It's probably Data-Validation. It has a tab called "Input Message" that
will act as you describe. This is normally used to describe to the user what
must go in a cell, but it can also be used a general comment.

"JB Christy" wrote:

I'm familiar with the comments that appear when your mouse hovers over a
cell. However, I noticed that in some of the templates that I downloaded
from Microsoft's site they had comments that appeared when the cell was
selected. So the comment always appeared when you tried to enter data in the
cell, regardless of how you selected the cell (arrow keys, tabbing, as well
as hover/mouse click).

Does anyone know how they did that? I can only do the "Insert Comment"
thing, and the comment only appears if they happen to move the mouse over
the cell.

a T d H v A a N n K c S e.

-JB



  #3   Report Post  
Posted to microsoft.public.excel.misc
JB Christy
 
Posts: n/a
Default Comments Appearing When Cell Is Selected (Not Hovered Over)

That's it! Thanks so much!

-JB

"Sloth" wrote in message
...
It's probably Data-Validation. It has a tab called "Input Message" that
will act as you describe. This is normally used to describe to the user
what
must go in a cell, but it can also be used a general comment.

"JB Christy" wrote:

I'm familiar with the comments that appear when your mouse hovers over a
cell. However, I noticed that in some of the templates that I downloaded
from Microsoft's site they had comments that appeared when the cell was
selected. So the comment always appeared when you tried to enter data in
the
cell, regardless of how you selected the cell (arrow keys, tabbing, as
well
as hover/mouse click).

Does anyone know how they did that? I can only do the "Insert Comment"
thing, and the comment only appears if they happen to move the mouse over
the cell.

a T d H v A a N n K c S e.



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
Returning Cell Comments from One Cell to Another RJS Excel Worksheet Functions 3 March 13th 06 11:39 PM
custimise the "IF" formula function [email protected] Excel Worksheet Functions 12 March 6th 06 11:18 AM
Cell Comments randomly move and resize regardless of settings Andrew Excel Discussion (Misc queries) 0 August 24th 05 08:49 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
How do I export comments into another excel column as cell content Hernan Excel Worksheet Functions 1 February 25th 05 02:17 PM


All times are GMT +1. The time now is 05:28 PM.

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

About Us

"It's about Microsoft Excel"