display comment on cell change

[samuel]

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?

 

[Peo Sjoblom]

If you just want to make someone aware of something when a cell is selected
you can select the cell, do data>validation, then select input message and
type a message, now every time this cell is selected a message will popup

 

[Gord Dibben]

samuel

Instead of a comment use a Data Validation input message in the cell.

Data>Validation>Allow>Any Value.

Input Message.......whatever you type.

When you arrow to the cell the DV message will show.


Gord Dibben MS Excel MVP

 

[samuel]

Is there a way to set the display box to be relative to the location of the
cell on the screen?

 

[Gord Dibben]

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