Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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).

See ValidityNew.ods

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

See ValidityNew.ods

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

See ValidityNew.ods

Regards

click to hide/show revision 4
No.4 Revision

updated 2015-12-30 13:14:12 +0200

Lupp gravatar image

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

See ValidityNew.ods

Regards

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

click to hide/show revision 5
No.5 Revision

updated 2015-12-30 13:18:34 +0200

Lupp gravatar image

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

See ValidityNew.ods

Regards

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