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.