AutoCorrect object (Excel)

Contains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).

Example

Use the AutoCorrect property of the Application object to return the AutoCorrect object. The following example sets Excel to correct words that begin with two initial capital letters.

With Application.AutoCorrect 
 .TwoInitialCapitals = True 
 .ReplaceText = True 
End With

Methods

• AddReplacement
• DeleteReplacement

Properties

• Application
• AutoExpandListRange
• AutoFillFormulasInLists
• CapitalizeNamesOfDays
• CorrectCapsLock
• CorrectSentenceCap
• Creator
• DisplayAutoCorrectOptions
• Parent
• ReplacementList
• ReplaceText
• TwoInitialCapitals

See also

• Excel Object Model Reference

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.