Auto Correct Properties

Name

Returns

Description

AutoExpand

Boolean

Set to True to enable automatic expansion in lists ListRange

AutoFillFormulasInLists

Boolean

Set to True to enable the creation of calculated columns created by automatic fill-down lists

Name

Returns

Description

Capitalize NamesOfDays

Boolean

Set/Get whether the first letters of days of the week are capitalized

CorrectCaps Lock

Boolean

Set/Get whether typing mistakes made by leaving the Caps Lock on are automatically corrected

Correct SentenceCap

Boolean

Set/Get whether the first letter of a sentence is capitalized if accidentally left in lowercase

DisplayAuto

Correct

Options

Boolean

Displays/Hides the AutoCorrect Options button. The default value is True. This is an Office-wide setting. Changing it in Excel will also affect all the other Office applications

Replacement List

Boolean

Returns a multidimensional array of strings. The first column of the array holds the word that will be changed, and the second column holds the replaced text. The Index parameter can be used to return an array containing a single word and its replacement

ReplaceText

Boolean

Set/Get whether Excel will automatically replace certain words with words from the AutoCorrect list

TwoInitial Capitals

Boolean

Set/Get whether Excel will automatically change the second letter of a word to lowercase if the first letter is uppercase

0 0

Post a comment