I used data - validation in excel to create an input message when selecting a
cell for data entry. How do I get the message to be close to the cell I
click instead of the message appearing on another part of the worksheet away
from the cell?

If you create a new message, doesn't it display right next to the cell that
was selected?

You can move that message with the cursor wherever you like, but,
AFAIK
it returns to it's parent cell on re-opening.

Have you tried moving it to the original cell?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"R" wrote in message
...
I used data - validation in excel to create an input message when selecting
a
cell for data entry. How do I get the message to be close to the cell I
click instead of the message appearing on another part of the worksheet
away
from the cell?

That is a known oddity. Check out this link. There are a bunch of other
bizarre oddities...

http://j-walk.com/ss/excel/odd/odd09.htm
--
HTH...

Jim Thomlinson


"R" wrote:

I used data - validation in excel to create an input message when selecting a
cell for data entry. How do I get the message to be close to the cell I
click instead of the message appearing on another part of the worksheet away
from the cell?

I wrote data validation message and the message displayed on the lower left
side of the cell and remained there even when I closed and reopened the
worksheet.

Did I so anything wrong?

Igbert

"RagDyer" wrote:

If you create a new message, doesn't it display right next to the cell that
was selected?

You can move that message with the cursor wherever you like, but,
AFAIK
it returns to it's parent cell on re-opening.

Have you tried moving it to the original cell?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"R" wrote in message
...
I used data - validation in excel to create an input message when selecting
a
cell for data entry. How do I get the message to be close to the cell I
click instead of the message appearing on another part of the worksheet
away
from the cell?