DV message linked
 

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.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

DV message linked
 

I do not understand what you need....
--
paul

remove nospam for email addy!



"Learning Excel" wrote:

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.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

DV message linked
 

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.

--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"paul" wrote:

I do not understand what you need....
--
paul

remove nospam for email addy!



"Learning Excel" wrote:

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.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

DV message linked
 

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.

DV message linked
 

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.

DV message linked
 

Did you download my revised workbook from

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


Gord

On Sat, 9 Feb 2008 16:56:00 -0800, Learning Excel
wrote:

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

DV message linked
 

DID IT !
THANK YOU!
--
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:

Did you download my revised workbook from

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


Gord

On Sat, 9 Feb 2008 16:56:00 -0800, Learning Excel
wrote:

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

DV message linked
 

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.

--
Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.

DV message linked
 

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

On Sun, 10 Feb 2008 07:01:55 -0000, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:

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.