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?

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?

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?

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?

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?