Application.DataEntryMode property (Excel)

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.



expression A variable that represents an Application object.


Value Description
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.


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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.