Skip to content

Latest commit

 

History

History
48 lines (31 loc) · 1.12 KB

Excel.Application.DataEntryMode.md

File metadata and controls

48 lines (31 loc) · 1.12 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.DataEntryMode property (Excel)
vbaxl10.chm133102
vbaxl10.chm133102
Excel.Application.DataEntryMode
1fd9f191-3aa5-2548-2d41-b9d2bc79654b
04/04/2019
medium

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.

Syntax

expression.DataEntryMode

expression A variable that represents an Application object.

Remarks

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.

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

[!includeSupport and feedback]