CheckSpelling Method

Microsoft Excel Visual Basic

Checks the spelling of a single word. Returns True if the word is found in one of the dictionaries; returns False if the word isn't found. Boolean.

expression.CheckSpelling(Word, CustomDictionary, IgnoreUppercase)

expression    Required. An expression that returns one of the above objects.

Word   Required String (used only with Application object). The word you want to check.

CustomDictionary   Optional Variant. A string that indicates the file name of the custom dictionary to be examined if the word isn't found in the main dictionary. If this argument is omitted, the currently specified dictionary is used.

IgnoreUppercase   Optional Variant. True to have Microsoft Excel ignore words that are all uppercase. False to have Microsoft Excel check words that are all uppercase. If this argument is omitted, the current setting will be used.

ShowCheckSpelling method as it applies to the Range object.

Checks the spelling of an object. This form has no return value; Microsoft Excel displays the Spelling dialog box Variant.

expression.CheckSpelling(CustomDictionary, IgnoreUppercase, AlwaysSuggest, SpellLang)

expression    Required. An expression that returns one of the above objects.

CustomDictionary   Optional Variant. A string that indicates the file name of the custom dictionary to be examined if the word isn't found in the main dictionary. If this argument is omitted, the currently specified dictionary is used.

IgnoreUppercase Optional Variant. True to have Microsoft Excel ignore words that are all uppercase. False to have Microsoft Excel check words that are all uppercase. If this argument is omitted, the current setting will be used.

AlwaysSuggest   Optional Variant. True to have Microsoft Excel display a list of suggested alternate spellings when an incorrect spelling is found. False to have Microsoft Excel wait for you to input the correct spelling. If this argument is omitted, the current setting will be used.

SpellLang   Optional Variant. The language of the dictionary being used. Can be one of the MsoLanguageID values used by the LanguageID property.

ShowCheckSpelling method as it applies to the Chart and Worksheet objects.

Checks the spelling of an object. This form has no return value; Microsoft Excel displays the Spelling dialog box

expression.CheckSpelling(CustomDictionary, IgnoreUppercase, AlwaysSuggest, SpellLang)

expression    Required. An expression that returns one of the above objects.

CustomDictionary   Optional Variant. A string that indicates the file name of the custom dictionary to be examined if the word isn't found in the main dictionary. If this argument is omitted, the currently specified dictionary is used.

IgnoreUppercase Optional Variant. True to have Microsoft Excel ignore words that are all uppercase. False to have Microsoft Excel check words that are all uppercase. If this argument is omitted, the current setting will be used.

AlwaysSuggest   Optional Variant. True to have Microsoft Excel display a list of suggested alternate spellings when an incorrect spelling is found. False to have Microsoft Excel wait for you to input the correct spelling. If this argument is omitted, the current setting will be used.

SpellLang   Optional Variant. The language of the dictionary being used. Can be one of the MsoLanguageID values used by the LanguageID property.

Remarks

To check headers, footers, and objects on a worksheet, use this method on a Worksheet object.

To check only cells and notes, use this method with the object returned by the Cells method.

Example

This example checks the spelling on Sheet1.

Worksheets("Sheet1").CheckSpelling