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?