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:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html