_Application.DataEntryMode 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.

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.

public:
 property int DataEntryMode { int get(); void set(int value); };

public int DataEntryMode { get; set; }

Public Property DataEntryMode As Integer

Property Value

Int32

Remarks

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.

Applies to