Application.DataEntryMode Property

Syntax

expression.DataEntryMode

expression A variable that represents an Application object.

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.

Example

This example turns off Data Entry mode if it's on.

Visual Basic for Applications
`If (Application.DataEntryMode = xlOn) Or _ (Application.DataEntryMode = xlStrict) Then Application.DataEntryMode = xlOff End If`

data data entry mode Data Entry Mode Property dataentry DataEntry mode? DataEntryMode DataEntryMode Property Find out if in dataentry mode? Set the program to accept data input?

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

See also: