DV message linked

[Learning Excel]

it is possible to have the data validation message(yellow square) linked to
have a message from another cell ( let's say A1) ? and changing as A1 changes.
In other words, DV is in B1 to B40 ( no dropdown, just with message), A1 says
"adjusted". Could a formula or... do this :
If B1,B2,or B40 is selected they will show in the DV message " adjusted" or
any other that A1 has ? Weird, ah?
Thanks for the answer, even if don't like it.

 

[paul]

I do not understand what you need....

 

[Learning Excel]

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.

 

[Gord Dibben]

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

 

[Learning Excel]

Wonderfull website.
Is not exactly my solution, but I think I can make it work.
So far is going good.
Thanks Gord.

 

[Gord Dibben]

Did you download my revised workbook from

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


Gord

 

[Learning Excel]

DID IT !
THANK YOU!

 

[Roger Govier]

Hi Gord

The only problem with making that change, is the DV message is linked to a
single cell.

Leaving the Text box as Debra has it, but just changing her code slightly to
alter the the "strMsg" variable would achieve the same thing, but (IMO) give
the OP greater flexibility.
Again, the Title value could be varied (linked to another cell) or omitted

If Target.Validation.InputTitle <> "" Or _
Target.Validation.InputMessage <> "" Then
strTitle = Target.Validation.InputTitle & Chr(10)
strMsg = Range("A1").Value

Equally, if they wanted, they could have a whole range of messages set up on
the Data Validation sheet, and use a case Select to vary the message
according to the contents of some other cell.

 

[Gord Dibben]

Thanks Roger.

Did not put a lot of thought into it.

Quick and dirty to pop up the one cell's text as OP requested.

Your revisions look good.


Gord