Errors._Default[Object] Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Allows the user to to access error checking options.

public:
 property Microsoft::Office::Interop::Excel::Error ^ default[System::Object ^] { Microsoft::Office::Interop::Excel::Error ^ get(System::Object ^ Index); };

public Microsoft.Office.Interop.Excel.Error this[object Index] { get; }

Default Public ReadOnly Property _Default(Index As Object) As Error

Parameters

Index: Object

Property Value

Error

Examples

In this example, a number written as text is placed in cell A1. Microsoft Excel then determines if the number is written as text in cell A1 and notifies the user accordingly.

<span class="label">Sub CheckForErrors()































































































































































































































































































































































































































































































































    Range("A1").Formula = "'12"































































































































































































































































































































































































































































































































    If Range("A1").</span>
<i>Errors</i>
<span class="label">.Item(xlNumberAsText).Value = True Then        MsgBox "The number is written as text."    Else        MsgBox "The number is not written as text."    End IfEnd Sub</span>

Remarks

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

Applies to

Share via