software

Hello
I have a list of definitions listed in 'info'!A1:a25. I would like to use
the cell contents of this list as data validation on numerous sheets. The
definitions are in the same row in the list that I would like use them in
Data Validation input message. ie. Data Validation Input Message for
'Company1'!A1 = 'info'!A1

Is there a way I can use a formula in Data Validation Input Message so I
dont have to retype the whole definition each time?
Thanks

You could use programming to add the cell contents to the data
validation input message, but you can't use a formula to create a
message in the data validation dialog box.

Sandy wrote:
gt; Hello
gt; I have a list of definitions listed in 'info'!A1:a25. I would like to use
gt; the cell contents of this list as data validation on numerous sheets. The
gt; definitions are in the same row in the list that I would like use them in
gt; Data Validation input message. ie. Data Validation Input Message for
gt; 'Company1'!A1 = 'info'!A1
gt;
gt; Is there a way I can use a formula in Data Validation Input Message so I
gt; dont have to retype the whole definition each time?
gt; Thanks--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html