Class AutoCorrect (Excel VBA)

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

Class Application gives access to class AutoCorrect.

Member in collection


To use a AutoCorrect class variable it first needs to be instantiated, for example

Dim act as AutoCorrect
Set act = Application.AutoCorrect

AutoCorrect class variables can be set using the Application.AutoCorrect procedure.

AddReplacement - Adds an entry to the array of AutoCorrect replacements.

DeleteReplacement - Deletes an entry from the array of AutoCorrect replacements.


AutoExpandListRange a Boolean value indicating whether automatic expansion is enabled for lists. When you type in a cell of an empty row or column next to a list, the list will expand to include that row or column if automatic expansion is enabled.

AutoFillFormulasInLists affects the creation of calculated columns created by automatic fill-down lists.

CapitalizeNamesOfDays true if the first letter of day names is capitalized automatically.

CorrectCapsLock true if Microsoft Excel automatically corrects accidental use of the CapsLock key.

CorrectSentenceCap true if Microsoft Excel automatically corrects sentence (first word) capitalization.

DisplayAutoCorrectOptions allows the user to display or hide the AutoCorrect Options button. The default value is True.

ReplacementList returns the array of AutoCorrect replacements.

ReplaceText true if text in the list of AutoCorrect replacements is replaced automatically.

TwoInitialCapitals true if words that begin with two capital letters are corrected automatically.