Tandaan
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o baguhin ang mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
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
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.