Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning Cell Comments from One Cell to Another | Excel Worksheet Functions | |||
custimise the "IF" formula function | Excel Worksheet Functions | |||
Cell Comments randomly move and resize regardless of settings | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
How do I export comments into another excel column as cell content | Excel Worksheet Functions |