ExcelBanter - Data Valitaion Input message

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Valitaion Input message (https://www.excelbanter.com/excel-worksheet-functions/77776-data-valitaion-input-message.html)

Data Valitaion Input message

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

Data Valitaion Input message

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