# Revision history [back]

Hi

DataValidity offers a solution with no macro or hidden column if it does not bother you to validate the added values to the list.

Explanations

• The list is defined for the entire column (which may not be good for performance)
• Source: A:A. This therefore includes the title of the column. A space is inserted before the word for it is listed first. Also for performance reasons it could be "reasonable" to reduce source and range of application.
• DataValidityError Alert tab▸Action set to Information. This allows the entry of a value not in the list (displays an information dialog).

Regards

Hi

DataValidity offers a solution with no macro or hidden column if it does not bother you to validate the added values to the list.

Explanations

• The list is defined for the entire column (which may not be good for performance)
• Source: A:A. This therefore includes the title of the column. A space is inserted before the word for it is listed first. Also for performance reasons it could be "reasonable" to reduce source and range of application.
• DataValidityError Alert tab▸Action set to Information. This allows the entry of a value not in the list (displays an information dialog).dialog). If you do not want the dialog, just uncheck Show error message...

Regards

Hi

DataValidity offers a solution with no macro or hidden column if it does not bother you to validate the added values to the list.column.

Explanations

• The list is defined for the entire column (which may not be good for performance)
• Source: A:A. This therefore includes the title of the column. A space is inserted before the word for it is listed first. Also for performance reasons it could be "reasonable" to reduce source and range of application.
• DataValidityError Alert tab▸Action set to Information. This allows the entry of a value not in the list (displays an information dialog). If you do not want the dialog, just uncheck Show error message...

Regards

 4 No.4 Revision Lupp 11632 ●30 ●86 ●159

Hi

DataValidity offers a solution with no macro or hidden column.

Explanations

• The list is defined for the entire column (which may not be good for performance)
• Source: A:A. This therefore includes the title of the column. A space is inserted before the word for it is listed first. Also for performance reasons it could be "reasonable" to reduce source and range of application.
• DataValidityError Alert tab▸Action set to Information. This allows the entry of a value not in the list (displays an information dialog). If you do not want the dialog, just uncheck Show error message...

Regards

(Edited by @Lupp :) Attached the announced Example.

 5 No.5 Revision Lupp 11632 ●30 ●86 ●159

Hi

DataValidity offers a solution with no macro or hidden column.

Explanations

• The list is defined for the entire column (which may not be good for performance)
• Source: A:A. This therefore includes the title of the column. A space is inserted before the word for it is listed first. Also for performance reasons it could be "reasonable" to reduce source and range of application.
• DataValidityError Alert tab▸Action set to Information. This allows the entry of a value not in the list (displays an information dialog). If you do not want the dialog, just uncheck Show error message...

Regards

(Edited by @Lupp :) Attached the announced Example.