Search Office
Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Excel 2010 > Excel 2010 Developer Reference > Reference > Application Object > Properties > Application.DataEntryMode Property (Excel)
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Developer Reference
Reference
Application Object
Properties
Application.ActiveCell Property (Excel)
Application.ActiveChart Property (Excel)
Application.ActiveEncryptionSession Property (Excel)
Application.ActivePrinter Property (Excel)
Application.ActiveProtectedViewWindow Property (Excel)
Application.ActiveSheet Property (Excel)
Application.ActiveWindow Property (Excel)
Application.ActiveWorkbook Property (Excel)
Application.AddIns Property (Excel)
Application.AddIns2 Property (Excel)
Application.AlertBeforeOverwriting Property (Excel)
Application.AltStartupPath Property (Excel)
Application.AlwaysUseClearType Property (Excel)
Application.Application Property (Excel)
Application.ArbitraryXMLSupportAvailable Property (Excel)
Application.AskToUpdateLinks Property (Excel)
Application.Assistance Property (Excel)
Application.AutoCorrect Property (Excel)
Application.AutoFormatAsYouTypeReplaceHyperlinks Property (Excel)
Application.AutomationSecurity Property (Excel)
Application.AutoPercentEntry Property (Excel)
Application.AutoRecover Property (Excel)
Application.Build Property (Excel)
Application.CalculateBeforeSave Property (Excel)
Application.Calculation Property (Excel)
Application.CalculationInterruptKey Property (Excel)
Application.CalculationState Property (Excel)
Application.CalculationVersion Property (Excel)
Application.Caller Property (Excel)
Application.CanPlaySounds Property (Excel)
Application.CanRecordSounds Property (Excel)
Application.Caption Property (Excel)
Application.CellDragAndDrop Property (Excel)
Application.Cells Property (Excel)
Application.Charts Property (Excel)
Application.ClipboardFormats Property (Excel)
Application.ClusterConnector Property (Excel)
Application.Columns Property (Excel)
Application.COMAddIns Property (Excel)
Application.CommandBars Property (Excel)
Application.CommandUnderlines Property (Excel)
Application.ConstrainNumeric Property (Excel)
Application.ControlCharacters Property (Excel)
Application.CopyObjectsWithCells Property (Excel)
Application.Creator Property (Excel)
Application.Cursor Property (Excel)
Application.CursorMovement Property (Excel)
Application.CustomListCount Property (Excel)
Application.CutCopyMode Property (Excel)
Application.DataEntryMode Property (Excel)
Application.DDEAppReturnCode Property (Excel)
Application.DecimalSeparator Property (Excel)
Application.DefaultFilePath Property (Excel)
Application.DefaultSaveFormat Property (Excel)
Application.DefaultSheetDirection Property (Excel)
Application.DefaultWebOptions Property (Excel)
Application.DeferAsyncQueries Property (Excel)
Application.Dialogs Property (Excel)
Application.DisplayAlerts Property (Excel)
Application.DisplayClipboardWindow Property (Excel)
Application.DisplayCommentIndicator Property (Excel)
Application.DisplayDocumentActionTaskPane Property (Excel)
Application.DisplayDocumentInformationPanel Property (Excel)
Application.DisplayExcel4Menus Property (Excel)
Application.DisplayFormulaAutoComplete Property (Excel)
Application.DisplayFormulaBar Property (Excel)
Application.DisplayFullScreen Property (Excel)
Application.DisplayFunctionToolTips Property (Excel)
Application.DisplayInsertOptions Property (Excel)
Application.DisplayNoteIndicator Property (Excel)
Application.DisplayPasteOptions Property (Excel)
Application.DisplayRecentFiles Property (Excel)
Application.DisplayScrollBars Property (Excel)
Application.DisplayStatusBar Property (Excel)
Application.EditDirectlyInCell Property (Excel)
Application.EnableAnimations Property (Excel)
Application.EnableAutoComplete Property (Excel)
Application.EnableCancelKey Property (Excel)
Application.EnableEvents Property (Excel)
Application.EnableLargeOperationAlert Property (Excel)
Application.EnableLivePreview Property (Excel)
Application.EnableSound Property (Excel)
Application.ErrorCheckingOptions Property (Excel)
Application.Excel4IntlMacroSheets Property (Excel)
Application.Excel4MacroSheets Property (Excel)
Application.ExtendList Property (Excel)
Application.FeatureInstall Property (Excel)
Application.FileConverters Property (Excel)
Application.FileDialog Property (Excel)
Application.FileExportConverters Property (Excel)
Application.FileValidation Property (Excel)
Application.FileValidationPivot Property (Excel)
Application.FindFormat Property (Excel)
Application.FixedDecimal Property (Excel)
Application.FixedDecimalPlaces Property (Excel)
Application.FormulaBarHeight Property (Excel)
Application.GenerateGetPivotData Property (Excel)
Application.GenerateTableRefs Property (Excel)
Application.Height Property (Excel)
Application.HighQualityModeForGraphics Property (Excel)
Application.Hinstance Property (Excel)
Application.HinstancePtr Property (Excel)
Application.Hwnd Property (Excel)
Application.IgnoreRemoteRequests Property (Excel)
Application.Interactive Property (Excel)
Application.International Property (Excel)
Application.IsSandboxed Property (Excel)
Application.Iteration Property (Excel)
Application.LanguageSettings Property (Excel)
Application.LargeOperationCellThousandCount Property (Excel)
Application.Left Property (Excel)
Application.LibraryPath Property (Excel)
Application.MailSession Property (Excel)
Application.MailSystem Property (Excel)
Application.MapPaperSize Property (Excel)
Application.MathCoprocessorAvailable Property (Excel)
Application.MaxChange Property (Excel)
Application.MaxIterations Property (Excel)
Application.MeasurementUnit Property (Excel)
Application.MouseAvailable Property (Excel)
Application.MoveAfterReturn Property (Excel)
Application.MoveAfterReturnDirection Property (Excel)
Application.MultiThreadedCalculation Property (Excel)
Application.Name Property (Excel)
Application.Names Property (Excel)
Application.NetworkTemplatesPath Property (Excel)
Application.NewWorkbook Property (Excel)
Application.ODBCErrors Property (Excel)
Application.ODBCTimeout Property (Excel)
Application.OLEDBErrors Property (Excel)
Application.OnWindow Property (Excel)
Application.OperatingSystem Property (Excel)
Application.OrganizationName Property (Excel)
Application.Parent Property (Excel)
Application.Path Property (Excel)
Application.PathSeparator Property (Excel)
Application.PivotTableSelection Property (Excel)
Application.PreviousSelections Property (Excel)
Application.PrintCommunication Property (Excel)
Application.ProductCode Property (Excel)
Application.PromptForSummaryInfo Property (Excel)
Application.ProtectedViewWindows Property (Excel)
Application.Range Property (Excel)
Application.Ready Property (Excel)
Application.RecentFiles Property (Excel)
Application.RecordRelative Property (Excel)
Application.ReferenceStyle Property (Excel)
Application.RegisteredFunctions Property (Excel)
Application.ReplaceFormat Property (Excel)
Application.RollZoom Property (Excel)
Application.Rows Property (Excel)
Application.RTD Property (Excel)
Application.SaveISO8601Dates Property (Excel)
Application.ScreenUpdating Property (Excel)
Application.Selection Property (Excel)
Application.Sheets Property (Excel)
Application.SheetsInNewWorkbook Property (Excel)
Application.ShowChartTipNames Property (Excel)
Application.ShowChartTipValues Property (Excel)
Application.ShowDevTools Property (Excel)
Application.ShowMenuFloaties Property (Excel)
Application.ShowSelectionFloaties Property (Excel)
Application.ShowStartupDialog Property (Excel)
Application.ShowToolTips Property (Excel)
Application.ShowWindowsInTaskbar Property (Excel)
Application.SmartArtColors Property (Excel)
Application.SmartArtLayouts Property (Excel)
Application.SmartArtQuickStyles Property (Excel)
Application.Speech Property (Excel)
Application.SpellingOptions Property (Excel)
Application.StandardFont Property (Excel)
Application.StandardFontSize Property (Excel)
Application.StartupPath Property (Excel)
Application.StatusBar Property (Excel)
Application.TemplatesPath Property (Excel)
Application.ThisCell Property (Excel)
Application.ThisWorkbook Property (Excel)
Application.ThousandsSeparator Property (Excel)
Application.Top Property (Excel)
Application.TransitionMenuKey Property (Excel)
Application.TransitionMenuKeyAction Property (Excel)
Application.TransitionNavigKeys Property (Excel)
Application.UsableHeight Property (Excel)
Application.UsableWidth Property (Excel)
Application.UseClusterConnector Property (Excel)
Application.UsedObjects Property (Excel)
Application.UserControl Property (Excel)
Application.UserLibraryPath Property (Excel)
Application.UserName Property (Excel)
Application.UseSystemSeparators Property (Excel)
Application.Value Property (Excel)
Application.VBE Property (Excel)
Application.Version Property (Excel)
Application.Visible Property (Excel)
Application.WarnOnFunctionNameConflict Property (Excel)
Application.Watches Property (Excel)
Application.Width Property (Excel)
Application.Windows Property (Excel)
Application.WindowsForPens Property (Excel)
Application.WindowState Property (Excel)
Application.Workbooks Property (Excel)
Application.WorksheetFunction Property (Excel)
Application.Worksheets Property (Excel)
Expand Minimize
This topic has not yet been rated - Rate this topic

Application.DataEntryMode Property (Excel)

Office 2010

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 .DataEntryMode

expression A variable that represents an Application object.

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.

This example turns off Data Entry mode if it's on.

VBA
Copy 
If (Application.DataEntryMode = xlOn) Or _ 
 (Application.DataEntryMode = xlStrict) Then 
 Application.DataEntryMode = xlOff 
End If
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.