Export (0) Print
Expand All
Expand Minimize

Application.DataEntryMode Property

Office 2007
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.

Syntax

expression.DataEntryMode

expression   A variable that represents an Application object.

Remarks

ValueMeaning
xlOnData Entry mode is turned on.
xlOffData Entry mode is turned off.
xlStrictData 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



Community Additions

ADD
Show:
© 2014 Microsoft