| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display comment on cell change
The comments will display on a mouse over.
Is there a way to make the comment display if a user uses the arrow keys to change cells? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display comment on cell change
If you just want to make someone aware of something when a cell is selected
you can select the cell, do datavalidation, then select input message and type a message, now every time this cell is selected a message will popup -- Regards, Peo Sjoblom "samuel" wrote in message ... The comments will display on a mouse over. Is there a way to make the comment display if a user uses the arrow keys to change cells? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display comment on cell change
samuel
Instead of a comment use a Data Validation input message in the cell. DataValidationAllowAny Value. Input Message.......whatever you type. When you arrow to the cell the DV message will show. Gord Dibben MS Excel MVP On Mon, 9 Apr 2007 11:32:01 -0700, samuel wrote: The comments will display on a mouse over. Is there a way to make the comment display if a user uses the arrow keys to change cells? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display comment on cell change
Is there a way to set the display box to be relative to the location of the
cell on the screen? "Gord Dibben" wrote: samuel Instead of a comment use a Data Validation input message in the cell. DataValidationAllowAny Value. Input Message.......whatever you type. When you arrow to the cell the DV message will show. Gord Dibben MS Excel MVP On Mon, 9 Apr 2007 11:32:01 -0700, samuel wrote: The comments will display on a mouse over. Is there a way to make the comment display if a user uses the arrow keys to change cells? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display comment on cell change
Not sure what you mean by "relative to the location".
Do you mean pop up somewhere other than next to the cell? Perhaps Debra Dalgleish's site would provide more flexibility. http://www.contextures.on.ca/xlDataVal12.html Here she provides a method for using a textbox for the message. You should be able to change the location of the textbox. Gord On Mon, 9 Apr 2007 13:00:04 -0700, samuel wrote: Is there a way to set the display box to be relative to the location of the cell on the screen? "Gord Dibben" wrote: samuel Instead of a comment use a Data Validation input message in the cell. DataValidationAllowAny Value. Input Message.......whatever you type. When you arrow to the cell the DV message will show. Gord Dibben MS Excel MVP On Mon, 9 Apr 2007 11:32:01 -0700, samuel wrote: The comments will display on a mouse over. Is there a way to make the comment display if a user uses the arrow keys to change cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i change cell display from #N/A to 0? | Excel Discussion (Misc queries) | |||
| How do I display the result of one cell each time a change anothe. | Excel Worksheet Functions | |||
| I want to change comment printing cell 3 to whats in cell 3 | Excel Worksheet Functions | |||
| Excel - Change cell display limitations | Excel Worksheet Functions | |||
| Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
Hybrid Mode
