AutoCorrect Object [Excel 2003 VBA Language Reference]

  • Article
Application
AutoCorrect

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

Using the AutoCorrect Object

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

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

Properties | Application Property | AutoExpandListRange Property | CapitalizeNamesOfDays Property | CorrectCapsLock Property | CorrectSentenceCap Property | Creator Property | DisplayAutoCorrectOptions Property | Parent Property | ReplacementList Property | ReplaceText Property | TwoInitialCapitals Property

Methods | AddReplacement Method | DeleteReplacement Method

Parent Objects | Application Object

Child Objects