display comment on cell change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
Is there a way to set the display box to be relative to the location of the
cell on the screen?
 
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
 
Back
Top