Application.CheckSpelling Method (Excel)

Published: July 16, 2012

Checks the spelling of a single word.

expression .CheckSpelling(Word, CustomDictionary, IgnoreUppercase)

expression A variable that represents an Application object.

Parameters

Name

Required/Optional

Data Type

Description

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.

Return Value

True if the word is found in one of the dictionaries; otherwise False.

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 property.

Community Additions

ADD
Show:
© 2014 Microsoft