AutoCorrect Object [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
AutoCorrect Object
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 to return the AutoCorrect object. The following example sets Microsoft Excel to correct words that begin with two initial capital letters.

Visual Basic for Applications
With Application.AutoCorrect
    .TwoInitialCapitals = True
    .ReplaceText = True
End With

See Also