Export (0) Print
Expand All
Expand Minimize

_Application.DataEntryMode property

Returns or sets Data Entry mode, as shown in the table below. When in Data Entry mode, you can enter data only in the unlocked cells in the currently selected range.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

int DataEntryMode { get; set; }

Property value

Type: System.Int32

Value

Meaning

xlOn

Data Entry mode is turned on.

xlOff

Data Entry mode is turned off.

xlStrict

Data Entry mode is turned on and pressing ESC won't turn it off.

Show:
© 2015 Microsoft