_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)
Syntax
'Declaration
Property DataEntryMode As Integer
Get
Set
'Usage
Dim instance As _Application
Dim value As Integer
value = instance.DataEntryMode
instance.DataEntryMode = value
int DataEntryMode { get; set; }
Property Value
Type: System.Int32
Remarks
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. |