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 of the currently selected range. Read-write.
|
Value |
Meaning |
|
xlOn |
Data Entry mode on. |
|
xlOff |
Data Entry mode off. |
|
xlStrict |
Data Entry mode on, and ESC will not exit the Data Entry mode. |
Example
This example turns the Data Entry mode off if it is on.
If (Application.DataEntryMode = xlOn) Or _
(Application.DataEntryMode = xlStrict) Then
Application.DataEntryMode = xlOff
End If