DataEntryMode Property

Applies To

Application object.

Description

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.

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.

If (Application.DataEntryMode = xlOn) Or _
    (Application.DataEntryMode = xlStrict) Then
        Application.DataEntryMode = xlOff
End If