NamedRange::Validation Property
Gets a Validation object that represents data validation for the NamedRange control.
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Property Value
Type: Microsoft.Office.Interop.Excel::Validation^A Validation object that represents data validation for the NamedRange control.
You must use the Startup event handler of a worksheet to add validation to a named range. For more information about the Startup event handler, see Events in Office Projects.
The following code example uses the Validation property to verify that a string with at least three characters is entered into a NamedRange. The SetValidation method must be called from the Startup event handler.
This example is for a document-level customization.
Show: