DataEntryMode Property

         Example         Applies To

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.