Wonderfull website.
Is not exactly my solution, but I think I can make it work.
So far is going good.
Thanks Gord.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Gord Dibben" wrote:

You can have the DV message linked to the contents of a cell.

Debra Dalgleish has a sample workbook which shows how to use a TextBox from the
Drawing Toolbar as the contents of the DV message.

http://www.contextures.on.ca/xlDataVal12.html

What you do is download that file then change the TextBox from the Drawing
Toolbar to a TextBox from the Control Toolbar, which can be linked to a cell and
its contents.

Then you change the code Debra supplies to point to the new TextBox with the
linked cell and make a few other changes to the code.

A bit of work, but can be done and Debra has done the Lion's share of the work.

I have uploaded a workbook based on Debra's original to this site. You can
download from there.

http://www.freefilehosting.net/download/3bl24


Gord Dibben MS Excel MVP

On Sat, 9 Feb 2008 14:28:00 -0800, Learning Excel
wrote:

Is a little complicated and will save me time, but I guess is not the use of
DV at all.
What I'm trying to achieve, paul, is the easy filling of cells X base in
other cells Z having a message telling me what's in cell Z all the time.
If you read carefully my first post, it will take you to the point of what I
need, not
what I need it for ( wich is harder to explain ).However as I have not get any
answer ( and I appreciate your interest and help) I guess it can not be done.
Thanks.