XmlMappedRange.Errors Property

Definition

Namespace:

Microsoft.Office.Tools.Excel

Assembly:

Microsoft.Office.Tools.Excel.dll

Gets an Errors object that enables you to access error checking options of an XmlMappedRange control.

public:
 property Microsoft::Office::Interop::Excel::Errors ^ Errors { Microsoft::Office::Interop::Excel::Errors ^ get(); };

public Microsoft.Office.Interop.Excel.Errors Errors { get; }

member this.Errors : Microsoft.Office.Interop.Excel.Errors

Public ReadOnly Property Errors As Errors

Property Value

Errors

An Errors object that enables you to access error checking options of an XmlMappedRange control.

Examples

The following code example inserts a number written as text into an XmlMappedRange, and then uses the Errors property to determine whether the number is written as text. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

private void CheckForErrors()
{
    this.CustomerLastNameCell.Formula = "'12";

    if (this.CustomerLastNameCell.Errors[
        Excel.XlErrorChecks.xlNumberAsText].Value)
    {
         MessageBox.Show("The number is written as text.");
    }
    else
    {
        MessageBox.Show("The number is not written as text.");
    }
}

Private Sub CheckForErrors()
    Me.CustomerLastNameCell.Formula = "'12"

    If Me.CustomerLastNameCell.Errors( _
        Excel.XlErrorChecks.xlNumberAsText).Value Then
        MsgBox("The number is written as text.")
    Else
        MsgBox("The number is not written as text.")
    End If
End Sub

Remarks

Reference the Errors object to view a list of index values associated with error checking options.